This content has been marked as final. Show 7 replies
It can be done as given below:
CASE WHEN Currency = 'USD' THEN round(dollar_column, 0) ELSE round(dollar_column, 2) END
Column Properties --> Data Format
1. check "Override Default Data Format"
2. Treat Numbers As "Number"
3. Decimal Places select "upto 2" in the drop down.
This should do the trick.
Let me know if this helped.