Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can some help me figure out why the following calculation would return a zero if I don't have the [Date - Invoiced] field in the table? I've created measures like this in the past without the field being used in the condition and they've worked.
I've tried the AGGR (with Rep Name and/or date) function in the sum and that's not working either.
if([Date - Invoiced] >= [Territory - Level 1 Rep Start Date], sum([Amount - Shipped/Fulfilled USD]), 0)
Rep Name | Sales |
SMITH, JOHN | $0 |
Try this may be
Sum(If([Date - Invoiced] >= [Territory - Level 1 Rep Start Date], [Amount - Shipped/Fulfilled USD]))
can you share your file pls
Thank you!
I thought this worked, but unfortunately it's not. I'm seeing very results that are much higher than expected.
I can't - this is sales data.