Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to compute a set analysis in the back end instead of the frond end. The set analysis is basically an "Aged Value" within different range but with 3 differents date to check:
1) Fixed_Value_Date: day of contract creation -> has to be equal or anterior to Date to be sure contract has been created
2)Due_Date: expected day of payment -> Aged Field to be within range
3)Clearing_Date: effective day of payment -> has to be superior to Date (not payed yet)
A set expression for the range 0-30days would be:
Sum({<Fixed_Value_Date={"<=GetFieldSelections(Date)"}>*<Due_Date_Corrected={">GetFieldSelections(Date)<=GetFieldSelections(Date)+30))"}>*<Clearing_Date={">GetFieldSelections(Date)"}>}TOT_Invoiced)
NOTE: i cleared Date(Date#()) around getfieldselections for lisibility
Any ideas ?
hi
If all the date field is connected to calendar,
I would try a solution with flag on a calendar for each of the cases you write up,
And in set analysis calculate