Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create a sheet to display difference between previous month and current month data amounts.
So far I have tried to get amount difference for current month but no luck. Ideally I should get amount difference for every month.
My script is as follows (see attached project also):
sum({1<Date = {">=$(=monthstart(Today()))<=$(=monthend(Today()))"}>}Amount) - sum({1<Date = {">=$(=monthstart(AddMonths(Today(), -1)))<=$(=monthend(AddMonths(Today(), -1)))"}>}Amount)
but it gives me incorrect results. Any Ideas?
Hi Egor,
Please see the below screenshots and attached qvf file:
As you can see from the above, based on user's selection "Current Month and Previous Month" numbers change.
Here is the expression for "Current - Previous":
In the attached qvf, please see the sheet name "New Calculation".
And if this answers your question, can you please mark this answer as the correct answer?
Thank you.
Hi Egor,
Can you check the new calculation sheet in the attached app? I created three text boxes, try to close the whole expression with brackets:
Hope this helps.
Thanks
Hello Sinan,
Yes it works, thank you very much!
Also how do I get amount difference not only for current month, but for every (e.g. selected) month?
Hi Egor,
Please see the below screenshots and attached qvf file:
As you can see from the above, based on user's selection "Current Month and Previous Month" numbers change.
Here is the expression for "Current - Previous":
In the attached qvf, please see the sheet name "New Calculation".
And if this answers your question, can you please mark this answer as the correct answer?
Thank you.
Thank you Sinan! That's all I need!
You are welcome.
Hi, I am also stuck here. It will give the correct month but not give any values, it gives 0 value. Please find the screenshot.