Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I would like to create a Table with a variance between the previous day and the Current day.
What could I use in the set analysis to achieve this variance and variance Percentage?
Date | Sales Amount | Variance | Variance% |
20150701 | 10000 | 0 | 0% |
20150702 | 12000 | 2000 | 20% |
20150703 | 9000 | -3000 | -25% |
20150704 | 5000 | -4000 | -44% |
20150705 | 15000 | 10000 | 200% |
20150706 | 3000 | -12000 | -80% |
20150707 | 18000 | 15000 | 500% |
Thank you
PFA
WOW! Thanks
Please find the attached
1.Expression 1 = sum[(Sales Amount])
2. expression 2 =sum([Sales Amount])- Above([Sales Amount],1)
3. Expression 3 = = (sum([Sales Amount])-Above([Sales Amount]))/Above([Sales Amount])
PFA
Regards
Ankit Bisht