Optimize Expression without IF

[Anonymous]

Dear all,

This is my expression : Num( Sum(Sale) / Sum( Quantity)*100,'#.#')&'%'

I''d like to reduce '%' when the result of sum equal zero and without IF expression. I need your help,pleaseee!!

[jonathandienst · Accepted solution]

Do you mean hide the % when the value is zero?

In what context do you want to display this number?

You could do this:

Num(Sum(Sale) / Sum( Quantity)*100, '0.0%;-0.0%';0)

This will use the appropriate format for positive, negative and zero respectively

[Anonymous]

Thank you very very much jontydkpi‌

[Anonymous]

Hi jontydkpi‌,

I am so sorry about that. Last day, I just check the zero value  and I miss to check correct format.

I provide the following photo:

I wanna format % as the left photo. Can you give me advice for this problem?

Regards!

Kirk

[jonathandienst]

Well the %format effectively multiplies by 100, so 0.5 displays as 50%. Just remove the *100 from the expression.

=Num(Sum(Sale) / Sum( Quantity), '0.0%;-0.0%';0)

[Digvijay_Singh]

Do you have Comma ',' before last zero? I guess it should be semicolon. I think 0.0% and -0.0% and the 0 are separated by semicolon and enclosed with apostrophe, try this - '0.0%;-0.0%;0'. jontydkpi might have typo in last response.

[Anonymous]

yup, thank you and.. the number after dot will be rounded.

The data after remove *100 :

I wanna get the number after dot. I dont wanna be rounded number. Like left value. Do you mind if you .... fix it again ? ?