I am trying to take a field then divide it by a percentage to get a value that is marked up.
An example would be you have $2 and want a 5% mark up, so you would divide 2 by .95 to get $2.10 (rounded).
The field in my table is set to Single for size then formatted to percent. On my form, I have a calculated field doing :
=([Price]+IIf(IsNull([Freight]),0,[Freight])+(IIf(IsNull([LampPrice]),0,[LampPrice])*IIf(IsNull([NumberOfLamps]),0,[NumberOfLamps])))
This gets my "true" cost of an item. I then want to divide it by my field ([GP]) to get my mark up. But when I do the above expression divided by [GP], I get some pretty weird results until I go over 100%, then it works how it should. Anything below 100% has some pretty off the wall multipliers.
I want the [GP] field to display as a percent, but the ACTUAL number would be different. So the users would enter 2%, but the expression would get divided by .98. What do I need to change to accomplish this?
An example would be you have $2 and want a 5% mark up, so you would divide 2 by .95 to get $2.10 (rounded).
The field in my table is set to Single for size then formatted to percent. On my form, I have a calculated field doing :
=([Price]+IIf(IsNull([Freight]),0,[Freight])+(IIf(IsNull([LampPrice]),0,[LampPrice])*IIf(IsNull([NumberOfLamps]),0,[NumberOfLamps])))
This gets my "true" cost of an item. I then want to divide it by my field ([GP]) to get my mark up. But when I do the above expression divided by [GP], I get some pretty weird results until I go over 100%, then it works how it should. Anything below 100% has some pretty off the wall multipliers.
I want the [GP] field to display as a percent, but the ACTUAL number would be different. So the users would enter 2%, but the expression would get divided by .98. What do I need to change to accomplish this?