7 Replies Latest reply: Jan 28, 2011 8:08 AM by Fernando Tonial

# set analysis command

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,

• ###### set analysis command

You can try this.

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

• ###### set analysis command

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)

• ###### set analysis command

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

• ###### set analysis command

In don't understand you

• ###### set analysis command

can you post your logic ?.

• ###### set analysis command

regards

Bumin

• ###### set analysis command

you try a sum with if, not set analysis

`Sum(If(days_open<30,amount))`