5 Replies Latest reply: Aug 2, 2017 8:17 PM by Yeo Poh sai

# Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar))

Hi All

I have a Pivot table 1 , which is working fine, i like to convert it to straight table.

Dimension :-

COMPANY_PAY

=If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2),

If(aging_ar >= 61 and aging_ar <= 90, Dual('61-90', 3),

If(aging_ar >= 91 and aging_ar <= 120, Dual('91-120', 4), Dual('>121 ', 5)))))

Expresion :-

Sum(total_ar)

I like to convert it into straight table. Hope some one can advise me.

I try on Table 2 it display null :-

Dimension :-

COMPANY_PAY

Expresion :-

sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar))

The error is above expression.

Pauk Yeo

• ###### Re: Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

Hi All

Enclosed My QVW file.

If the expression no more syntax error , the first column of table 1 and 2 should be display same amount.

Paul Yeo

• ###### Re: Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

I haven't open your application. Condition should like below

sum(If(aging_ar >= 1 and aging_ar <= 30,total_ar))

• ###### Re: Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

Hi Paul Sir,

Try this

sum(If(aging_ar >= 1 and aging_ar <= 30,total_ar))

• ###### Re: Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

PFA....

• ###### Re: Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

Hi P M

thank you very much it work fine now.

Paul