Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I'm struggling to find a total for the last quarter.
I would like to always see a total from the last quarter.
Sum (distinct VST_Call.Call)
I have a master calendar called MASTER_CAL.Date and also a calendar for the quarters called MASTER_CAL.Quartes (Q1, Q2, Q3, Q4). In addition, the VST_CALL has a date field called "createdate". This is linked to the master calendar.
How do I get the total from the last quarter?
I am desperate ...
Hello,
To get last quarter data you can use below set analysis code.
Sum(distinct {<createdate= {">=$(=Quarterstart(Max(createdate),-1))<=$(=QuarterEnd(Max(createdate),-1))"}>}
VST_Call.Call)
Hope this helps.
Thanks,
Ashutosh
You can try set analysis:
Sum ({<MASTER_CAL.Quartes={"=$(=max(MASTER_CAL.Quartes))"}>} distinct VST_Call.Call)
Hello,
To get last quarter data you can use below set analysis code.
Sum(distinct {<createdate= {">=$(=Quarterstart(Max(createdate),-1))<=$(=QuarterEnd(Max(createdate),-1))"}>}
VST_Call.Call)
Hope this helps.
Thanks,
Ashutosh
Thank you all 🙂