Set analysis

[nareshthavidishetty]

Hi,

I'm getting the below error in set analysis.Please let me know the correct logic.

Thanks..

[saimahasan]

Hi Naresh

Since your MaxReportedDate field must be having only single record, you cantake that value in variable by using

LET vMaxDate = Date(Peek('Max_A',0,'B'));

Then using the set expression:

=Sum({$<Date={"$(vMaxDate)"}>}Sales)

You can get the required output.

[vishsaggi]

Yes, I missed it. Thanks.