topic Re: Set Analysis - Previous Dates in App Development

Set Analysis - Previous Dates

asmithids — Wed, 24 Oct 2018 22:01:08 GMT

Hello,

I have a fairly simple set expression where I need to sum all payment amounts prior to the current month. I have the following expression to do that but, I'm not getting any data. When I remove the "less than sign" from the month set, I get numbers. Cleary, the "less than sign" on the month set is the problem but, I don't know why.

Has anyone solved this problem? I've checked the Community and see that what I have scripted seems to be correct but, it's not working.

Sum({$<Year={$(=Max(Year))}, Month=“<$(=Month(Today()))"}>}PaymentAmount)

Thank you in advance for any help!!

Re: Set Analysis - Previous Dates

achettipalli — Wed, 24 Oct 2018 22:36:44 GMT

Hi Alec,

This returns the sum of all payments of the recent year prior to current month.

=sum({$<Year={"$(=Max(Year))"},Month={"<$(=Max(month(today())))"}>}PaymentAmount)

good luck!

Avinash

Re: Set Analysis - Previous Dates

asmithids — Thu, 25 Oct 2018 00:19:03 GMT

That worked! Thanks Avinash!

Re: Set Analysis - Previous Dates

achettipalli — Fri, 26 Oct 2018 13:21:38 GMT

Glad it helped.

Cheers!