Grouping help

[dhanu_today]

Hi All,

I have the req below.

I have to show the the bifurgation of total amount into increase and decrease columns with respect to their id's.

But in the design level i have to show only the increase and decrease rate and no need to show the Ids.

The fields are coming from different tables.Help in design level is added adv.

Please find the attached doc for clarification.

Thanks

Dhanu

Message was edited by: dhanu today

[giakoum]

see attached

[dhanu_today]

Thanks Loannis...Its my bad..I dont have increase and decrease fields as input.

Rgds,

Dhanu

[dhanu_today]

Any one is there !!!

Thanks,

Dhanu

[#5]

Dhanu,

1) Either in SCRIPT  (if you want 3 fields)

LOAD Amount,

if(Amount > 0, Amount) as Increase,

if(Amount < 0, Amount) as Decrease

FROM xxxx

2) Or In the UI

expression Increase for ex: sum(if(Amount>0, Amount))

Fabrice

[nirav_bhimani · Accepted solution]

Try to create a Flag in the script,

If (Amount>0, 'Inc', 'Dec') as Flag

Then used this condition in the Set Analysis like

Sum({<Flag={'Inc'}>}Amount) //for Increase

Sum({<Flag={'Dec'}>}Amount) //for Decrease

Hope this might resolved your problem

Regards,

Nirav Bhimani