Staying within the 100% (1 Viewer)

[Czeszyn]

I am stumped. When I worked on a formula first in excel:
IFERROR(Min(100%-(H8/G8)),0) This did first gave a 0 if there was not number, but the main part that I want to use in my access database is the part that it uses the min so that the percentage will not go over 100%.

I have the following in my access:
[TotalAmount]/[EffectiveCapacity] this formula works, but I want it to go over 100%.

Other wise for the total month, I get numbers like 350%.

Is there away to make it only go up to 100%?

Thank you.
Tony

 

[CJ_London]

there is no equivalent to the excel min function in Access. Instead you need to write a UDF (a public function in a standard (not form) module)

public function cMin(val1 as double, val2 as double) as double

    if val1<val2 then cmin=val1 else cmin=val2

end function

 

[Czeszyn]

Hi CJ_London
Thank you for responding. Would I do that right in the form, then the property?