Is it possible to put this expression in the script ?

[Cap]

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 ?

[MendyS]

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