Percent Discount Code

[Guest]

Can anyone tell me why this doesn't work?

If RetailPurchase > 0 Then
HardwareDisc= (RetailPurchase - WhlslePurchase) / RetailPurchase
End If

I have it in a button control...when the button is pushed a bunch of
calculations happen...this one keeps returning 0.00%...which is wrong:

When the Retail is $100 and Whlsle is $75 is should return 25%.

I'm sure I just have the syntax wrong but can't seem to find out how.

I have it as >0 because I only want it to return a number if Retail is
entered.

Thanks in advance,
Gee

 

[Guest]

should work.....obviously the equation is ok...

something dimensioned wrong? is the definition of the data in the table as
numeric?