Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
egoss_cynosure_
Contributor II
Contributor II

Calculation not working as expected

 

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 NameSales
SMITH, JOHN$0
Labels (3)
5 Replies
sunny_talwar

Try this may be

Sum(If([Date - Invoiced] >= [Territory - Level 1 Rep Start Date], [Amount - Shipped/Fulfilled USD]))
sugathirajkumar
Creator
Creator

can you share your file pls

egoss_cynosure_
Contributor II
Contributor II
Author

Thank you!

egoss_cynosure_
Contributor II
Contributor II
Author

I thought this worked, but unfortunately it's not. I'm seeing very results that are much higher than expected.

egoss_cynosure_
Contributor II
Contributor II
Author

I can't - this is sales data.