Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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.
Are you trying to do it in the script or front end?
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.
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?
Thank you Jagan...