Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
How to calculate dynamically total sales which is not based on maxdate which should be based on seletion
If select any month of the corresponding year then total sales should display
Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}sales)
It returns only based on maxdate.
Any Ideas??
Hi,
try this
Sum({$<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}Amount)
-Joyson G
Not sure I completely understand. You want to see last three months and total as the current month?
Yes Sunny!!
But which is not based on maxdate it should be based on selection.
Is it possible to achieve?
Pls help
Hi try this,
Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=Month(Date))'}>}Amount) from last 3 months
May be like this:
If(Dimensionality() = 0, Sum(Amount), Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}Amount))