Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
Thank you, Joaopaulo. I got the concept now with your explanation.