Need help finding the inverse of a %

[jeffm777]

I have a formula that gives me a %:

if Sum ({@# In-Stock Requests}, {@Month}) = 0 then 0 else
Sum ({SalespersonPerformance.NumOfRegSales}, {@Month}) / Sum ({@# In-Stock Requests}, {@Month}) *100

If # of in-stock requests = 4073 and the # of regular sales = 750, this gives me a % of 18.41. However, I need to see a lost sales % so that would be the inverse of 18.41 (81.59%).

Does anyone know of a formula I can use to get this?

Thanks!!!

 

[jeffm777]

Nevermind. I answered my own question.

Instead of...

if Sum ({@# In-Stock Requests}, {@Month}) = 0 then 0 else
Sum ({SalespersonPerformance.NumOfRegSales}, {@Month}) / Sum ({@# In-Stock Requests}, {@Month}) *100

I used...

if Sum ({@# In-Stock Requests}, {@Month}) = 0 then 0 else
100 - Sum ({SalespersonPerformance.NumOfRegSales}, {@Month}) / Sum ({@# In-Stock Requests}, {@Month}) *100

 

[SkipVought]

It's just 1 minus [the value you just calculated].

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}