0 not recognized in code

[lliberm1]

I have a basic if formula that is looking to see if the local currency is 0 and that country of issue and country of risk are united states that local currency will update to united states (pic1).

the result of this (pic2) still shows local currency as 0 in these scenarios.

everything is vstring (pic3)

what could possibly be causing this?

[Thableaus · Accepted solution]

Hi @lliberm1 

Instead of doing [LOCAL CURRENCY] = "US Dollar", try just to leave "US Dollar"

....THEN "US Dollar"....

ELSE [Local Currency]

You don't need to make your field explicit in the result of the if statement.

Cheers,