set analysis command

[#1]

I want to create an account due where the amount is split up by age in days.

Example

debno total amount days_open < 30 days 30-60 days > 60 days

XXXX 300,00 45 0 300,00 0

YYYY 250,00 11 250 0 0

a try, don't work

Sum( {< days_open < [30] >} Amount)

Sum( {< days_open >= [30] AND days_open < [60] >} Amount)

Sum( {< days_open >= [60] >} Amount)

Can some body give me a hint?

Regards,

[#2]

You can try this.

Sum( {< days_open = {"<30"} >} Amount)
Sum( {< days_open = {">30 < 60"} >} Amount)
Sum( {< days_open = {">60"}>} Amount)

[#3]

Sorry but I get all amounts in the first column. (<30)

So the set analysis don't work well

days_open is a computed column

Floor

(if( isnull(BETAALDATUM), Date(Now()) , BETAALDATUM)- FACTDATUM)

[#4]

Hi,

you can try like this way Try to create the Computation Field in Back end and then apply the set analysis which has sent in previous post by sHi, you can try like this way Try to create the Computation Field in Back end and then apply the set analysis which has sent in previous post by Fernando.

Regards,

Santhosh

[#5]

In don't understand you

[suniljain]

can you post your logic ?.

[bumin]

please find attached your example

regards

Bumin

[#8]

you try a sum with if, not set analysis

Sum(If(days_open<30,amount))