Calculate %

[johnan]

Hi, i have a text like this:

='Utfall: ' & round (Count(if([Antal fel] >=2, ([Package Number])))/count([Package Number])*100,0.01) & ' %'

It's give me 5,62% and i want to show 94,38 % instead of 5,62

Where can i put like 100-

Br

[zhadrakas · Accepted solution]

try like this:

='Utfall: ' & round (100-Count(if([Expression2] >=2, ([Expression2])))/count([Expression2])*100,0.01) & ' %'

regards

tim

[johnan]

Easy, haha. Just blind today 🙂 

Thanx Mate!!