Quick question...

[Rogue Programme]

=[TxtActualScore]/[TxtMaxScore]*100............

is what i am using to give me a percentage. For example:

(Actual Score) 8 / (Max Score) 9 x 100 = 88.9 %

There is the possibility that in some cases the Actual Score and Max Score are not applicable. I thought that if i enter '0' in Max Score and '0' in Actual score then the unbound calculation field that performs and displays the result for me would either show 0 % or 100 %.

Instead it displays #Num!......this is not good!

Does this make sence to anyone?!?!?!?!?!?!?

Cheers

MIke

 

[jon98548]

Any time you put a 0 in the denominator, you will get an error message no matter what comes next.

 

[Rogue Programme]

Yes ok, but is there a way round this?

 

[Mile-O]

=IIf([TxtActualScore]>=0,IIf([txtMaxScore]=0,"-",[txtActualScore]/[TxtMaxScore]*100),[txtActualScore]/[TxtMaxScore]*100)

 

[Rogue Programme]

Cheers Mile....you've bailed me out again!

Mike