topic Re: Return positive values as negative values with conditional statement in App Development

Return positive values as negative values with conditional statement

Mt3 — Tue, 23 Aug 2022 13:43:01 GMT

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?

Re: Return positive values as negative values with conditional statement

Digvijay_Singh — Tue, 23 Aug 2022 14:19:00 GMT

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