Different number format; same expression?

Thu, 20 Jun 2013 14:22:05 GMT

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:

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.

topic Different number format; same expression? in QlikView

Different number format; same expression?