Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have customers with sales and credits by year, by month. I want that when the user is selecting multiple months to sum only the sales of the last month.
I tried without succes a formula like this :
sum({$<Month ={vMonth}>} Sales)
where vMonth is a varibale that calculates the max(Month)
If someone has another idea I'll apreciate.
Try:
sum({$<Month ={'$(vMonth)'}>} Sales)
Hi
sum({$<Month ={'$(vMonth)'}>} Sales)
Hope it helps
Hi,
I tried this but is still not working.
Thanks
I fund myself the answer, I should use an if, like this :
sum(if(Month=vMonth, Sales ,0))
Thank you!!!