Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey I would like to something like, sum TransactionAmount thats between start and end dates, ( i would like to get the sum of transactions in a selected month )
if anyone could please point me in the right direction.
SUM( {< Year=, PeriodName=, postingDate={"<=$(vEndDate)" AND ">=$(vStartDate)"} >} TransactionAmount)
thanks.
Bon.
I still haven't fixed this. I think all solutions provided is correct but currently im using the incorrectly data field. so I'll look further into which field is related.