negative and positive values

[#1]

hi Friends,

i have a calculated field Nett, using that i would like to show in my chart as ,

if Nett is -ve, it should be Money Lending , +ve means Money Borrowing and these two should come under in single column Money Market.

Nett	Money Market
(1,622)	Money Lending
5,297	Money Borrowing
12,373	Money Borrowing

Please help me..

[sunny_talwar]

Are you trying to do it in the script or front end?

[jagan · Accepted solution]

Hi,

Try like this in script, it is the best method

LOAD

*,

If(Nett < 0, 'Money Lending', 'Money Borrowing') AS [Money Market]

FROM Datasource;

Regards,

jagan.

[Anonymous]

What exactly you want??

If you want to create a new field like Money Market, the best we can do at script level is what Jagan have already suggested..

Let us know if it is sort out your issue?

[#5]

Thank you Jagan...