Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why would this expression give me Error in set modifier ah doc element list?
=SUM({<FCST_DATE={'$(vPriorQuarter)'},FCST_AMT)
vPriorQuarter is a single end date of the latest quarter. That is what I want to use to identify the row of the FCST_AMT.
='vPriorQuarter = '& $(vPriorQuarter) produces 09-30-2015
"If you use this expression in a Straight Table with an empty label, what formula do you see in the heading? You should be able to see how the variable gets expanded, and that might show you what could be wrong."
I see 09-30-2015
I think you should probably add another dollar sign expansion -> $(=$(vPriorQuarter)), and secondly make sure that the date format for FCST_AMT is MM-DD-YYYY.
Try this may be:
=Sum({$<FCST_DATE={'$(=$(vPriorQuarter))'}>}FCST_AMT)
That was it! Thanks! I'll get the hang of this syntax one day!
So my guess was right ?!