Profit&Loss

[mohan2391]

hi

i have 2 fields as Amount & name. I want to show the families which r in profit & which r in loss seperately. How to do it ? How can i show ?

If amount is in +ve it means profit & if -ve it means loss.

[its_anandrjs]

Hi,

Check the attached app.

Regards

Anand

[its_anandrjs]

Hi,

If you have any data so provide that so we have look out the solution otherwise if this your answer so please check.

Regards

Anand

[#4]

Hi,

Try to put this in the script.

if(amount>0,Profit,Loss) as Category.

[zkn_0247]

In load script define condition if(amount <0,'loss','profit') as pnl_flag. now you can group your data on the basis of this flag.

[mohan2391]

Thank You.......