Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following equation which works when I select a specific record which has a specific AGE ... However, when this is displayed on a table with NO selections, it does not work. I provided what the data looks like below as well. What am I missing so that it shows the calculation per person on the table when there is no selection?
=Sum({<CreatedDate={"$(='>=' & Date(Today()-AGE, 'M/D/YYYY'))"}>}Upsell_ARR__c)
Person/Age
Bob/20
Phil/30
Jen/50
Person/CreatedDate/UpsellARR
Bob/11/20/2017/$10
Phil/12/20/2017/$20
Jen/3/1/2018/$30
Since you need dimension wise condition, set analysis isn't going to work... try this may be
Sum(If(CreatedDate >= Today() - AGE, Upsell_ARR__c))
Since you need dimension wise condition, set analysis isn't going to work... try this may be
Sum(If(CreatedDate >= Today() - AGE, Upsell_ARR__c))
Or this
Sum(Aggr(If(CreatedDate >= Today() - AGE, Upsell_ARR__c), Person, CreatedDate))
Thank you as always Sunny!