How i can do this ... ?

[#1]

How i can do this in set analysis????

if(AmortType='N',sum(if((Date(vToday) - Date(if(DateType='C',RefDate,DueDate)))>360,Debit-Credit)),

                 sum(if((Date(vToday) - Date(if(DateType='C',RefDate,DueDate)))>360,Debit-Credit)))

please help me.

Regards

Fernan Gonzalez

[Gysbert_Wassenaar · Accepted solution]

You can't do this with set analysis expressions as far as I know. Set analysis calculates sets to operate on. That's not what you're doing here. You use if statements to pick which sum expression to use and which field to use in comparisons. Set analysis can't help you with that. You need the if statements for that.

[#3]

thanks