Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if((sum({$<Month={SliderMonth}>}total [Sales Amount]) - sum({$<Month={MonthPlusOneCustomerAddDate}>}Total [Sales Amount])) / sum({$<Month={SliderMonth}>}total [Sales Amount]) >= SliderGrowthPercentage, sum([Sales Amount]))
What i want to do is change this logic to sum(MonthPlusOneCustomerAddDate) / sum(All months from slider to inception date)
So if the add date is january, and the slider is on april then the equation is as follows
sum(january) / sum(Jan-April)
Any thoughts?
Thanks,
Hi,
I hope the below will help you;
Sum( {$<Month={'=$(addmonth)'}>} amount ) / sum( {$<Month={'>=$(addmonth) <=$(slidermonth)'}>} amount )
regards
Rajesh