Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
I would like to write an expression to get % improvement in Sales by date comparison, but my expression seems like not working.
sum({$<Day = {$(=Only(Day))}>}Sales)-sum({$<Day = {$(=Only(Day)-1)}>}Sales)
Anyone could help?
I have attached the qvw file, table in excel sheet is the table that is needed to show on dashboard.
Thanks,
Chanel
Hi,
I saw in your data that you don't have consecutive days and day and day-1 compares consecutive days. If day is 8/12/2014, day -1 is 8/11/2014. Your dates are 1 week apart from each other.
Eduardo
Hi Chanel,
PFA file for solution.
Regards,
Jagan.
Thanks Jagan! I have tried it out and is working perfectly.
=RangeSum(sum(Sales), -Before(Sum(Sales))) / Alt(Before(Sum(Sales), 1))
This is first time to use rangesum, before and Alt functions, do you mind to briefly explain on this?
Hi,
Please find the explanation below
Rangesum(n1, n2, ....nm) - Will give you sum of n1 + n2 + ......+ nm (Even if one of the value is null you will get the sum for remaining values)
Before() - Will give you preceding column value of the same row
Alt() - will give the default value if expression value is null Ex: Alt(Expression, 'N/A') gives you 'N/A' if Expression returns null.
Hope this helps you.
Regards,
Jagan.
Lovely! Appreciate for your help!