Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone. I've managed to build up a table that sum revenues for a certain period based on my selection.
Now, I'd like to add a new column to my table showing revenues for the previous year, given the same period (in months) selected.
Please see screenshot for details.
Thanks in advance for your help!
Please note that
- the selected date field name is "selecteddate"
- the date I used in the if function is "recorddate"
- the revenues field name is "revenues"
May be this
Sum({<recorddate = {"$(='>=' & Date(AddYears(Min(selecteddate), -1), 'MM/YYYY') & '<=' & Date(AddYears(Max(selecteddate), -1), 'MM/YYYY'))"}>}revenues)
May be this
Sum({<recorddate = {"$(='>=' & Date(AddYears(Min(selecteddate), -1), 'MM/YYYY') & '<=' & Date(AddYears(Max(selecteddate), -1), 'MM/YYYY'))"}>}revenues)
Great, it worked like a charm.
Thanks a lot.
Can I just substitute "-1" with "+1" in order to add one year right?
Yes