Using Date in Set Analysis

[Sarmie_Akintona]

Hello All,

I am trying to use a Date Field, codenamed PayDate, in a Set Analysis. However, it's not turning out right for me. I want the summation of the 'Payment' Field from a particular date

Sum({<PayDate={">=$(=Date((PayDate), 'DD.MM.YYYY'))"}>}Payment)

This is not yielding any result whatsoever. Could anyone help me out here?

[joaopaulo_delco · Accepted solution]

Hi @Sarmie_Akintona !

        You cannot use a field in set analisys without agregation. 

Sum({<PayDate={">=$(=Date((PayDate), 'DD.MM.YYYY'))"}>}Payment)

You need to use something like this

Sum({<PayDate={">=$(=Date((Max(PayDate)), 'DD.MM.YYYY'))"}>}Payment)

You also can use a variable to set the date:

Sum({<PayDate={">=$(varDate)"}>}Payment)

[Sarmie_Akintona]

Thank you, Joaopaulo. I got the concept now with your explanation.