0 Replies Latest reply: Jun 20, 2013 11:59 AM by Adam Haithcox RSS

    Different number format; same expression?

    Adam Haithcox

      I'm trying to add a Total sales column along with a horizontally presented expression, which works, but I can't seem to format the Total column as currency seperate from the percentages. Here is my single expression:

       

      If(SecondaryDimensionality() = 0, If(Sum([Discount Percent]) > 0, Money(Sum([Sales Amount]))), [Discount Percent])

       

      And the result:

       

      Capture.PNG

       

      Any suggestions?

       

      UPDATE:

       

      This is what I went with. Probably not the most efficient, but it works:

       

      If(SecondaryDimensionality() = 0, If(Sum([Discount Percent]) > 0, Money(Sum([Sales Amount]))), (Num([Discount Percent] * 100, '##.0')) & '%' )

       

      Hope this helps someone in the future.