Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You can use the concept of Dimensionality() to do this. Look at the following Blog by Robert Mika: How to use - Dimensionality()
Dear Naresh,
Expression1: Total Sales % = Sum(SalesField) / Sum(TOTAL SalesField)
Expression2: % Sales by Country = Sum(SalesField) / Sum(TOTAL<Country_Field> SalesField)
Kind regards,
Ishfaque Ahmed
Hi,
My sales field contains expression
Closing Rate=[invoice count]/[Adjusted Tariff]
Can you please help me how to write the expression.
Not sure, but may be this:
If(Dimensionality() = 0, Num([invoice count]/[Adjusted Tariff], '#,##0.0%'), Num([invoice count]/[Adjusted Tariff], '#,##0'))
Hi,
It is not working,it gives me same output.
Hi Naresh,
Did you try with sunindia Expression With the Total Mode as Expression Total ?
I think you mean formatting as Expression's default, right?
This One
I guess we need both to be Expression default