Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All
II discovered a glitch that may cause your results to be erroneous;
The expression :
Sum({<YR=,Qtr=,MO=,DA=,TranDate={">=$(=MonthStart(today(),-12)) <=$(=AddMonths(today(),-12))"}>} Sales)
Will return correct results for Month To Date of Last year.
However if you try to make it "look" nicer and easier to read and insert a CRLF (Carriage Return Line Feed) before the "<=" sign the results are completely different.
Sum({<YR=,Qtr=,MO=,DA=,TranDate={">=$(=MonthStart(today(),-12))
<=$(=AddMonths(today(),-12))"}>} Sales)
So Be careful!
Can you supply an example?