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.