Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to convert field with positive values for the negative ones based on if condition in the load script.
So far I have tried following options:
if([Field1] = 'A',-([Field2]))
if([Field1] = 'A',([Field2]*-1))
Unfortunatelly none of them worked. Do you have any other suggestions?
Are you trying that in the script, Can you show the result in the table chart, how does it look, left aligned or right aligned? to identify if Field2 is a text field or not..
If you are trying in the script, can you share the complete statement, is it like this?
if([Field1] = 'A',Field2*-1,Field2) AS Field2Negative