Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need some help please, im trying to use the following formula to SUM up Sales Qty by rolling month,
(SUM({<TCODE={'IN'}, TXDATE={">=$(=date(addmonths(today(),-1)))"}>} QUANTITY))
What i want to see is my Total Sales Qty for Last month, then i will use the same formula to total 2 months ago, then 3 months ago.... problem is its not working 😞
TCODE = SALES TYPE
IN = INVOICES
TXDATE = TRANACTION DATE
Hi
Use RangeSum() Function
or
PFA
you can change directly in measure settings
Thanks
Hi
Use RangeSum() Function
or
PFA
you can change directly in measure settings
Thanks