This discussion is archived
7 Replies Latest reply: Nov 20, 2012 12:43 AM by 659358 RSS

data format

659358 Newbie
Currently Being Moderated
hey, any ideas how not to only show decimals for a certain currency e.g.

CASE WHEN Currency = 'USD' THEN no decimal places ELSE 2 decimal places END

thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points