gustavoavila
New Member
- Joined
- Feb 27, 2013
- Messages
- 15
Hi folks,
I'm trying to create a formula to compare total sales and sales until last week.
I've create this formula, but, only gives me the sales of the las week but I need the total sales until last week. Do you have any idea? I'm uploading an example to be more specific.
Example file: https://mega.co.nz/#!u4wzELJD!Gs3JnUJFHL9QShJW0z-zYW9ExTArVE8tMdkWWp3eEqM
Thanks in advance.
I'm trying to create a formula to compare total sales and sales until last week.
I've create this formula, but, only gives me the sales of the las week but I need the total sales until last week. Do you have any idea? I'm uploading an example to be more specific.
Code:
=IF(ISERROR((SUMPRODUCT((ProjectTable[Project]=[@Project])*(ProjectTable[Weeknum]=WEEKNUM(TODAY())-1);ProjectTable[@sales])
Example file: https://mega.co.nz/#!u4wzELJD!Gs3JnUJFHL9QShJW0z-zYW9ExTArVE8tMdkWWp3eEqM
Thanks in advance.