Percent multiplier

[kmclane]

I have a field from a table that has a number, ie 50, that represents a percentage. I have a calculated text box value on a report that is supposed to give a value that is the percent based on another text boxes value times the percentage. =[TotProfLoss]*[AgntPctProf]. If I format AgntPctProf as percent, it doesn't display properly, nor is the calculation correct. If I remove the format, I get the proper display, "50", but the calculation is again incorrect. It multiplys times 50 not 50%. This is probably simple to fix. The percentage amount can vary, so I can't just hard code it in.
Thanks, Ken.

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[jebry]

Hi Mitch!

Go ahead and format it as a percentage but change the value you are storing to .5. Then the display and the calc will be correct.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[kmclane]

This still isn't working. OK here are the settings. The residPct field in the buyrate table is Number, Single, 2 decimal places. The data entry form for the field is no format, 2 dec places. The text box that pulls from the table is Format percent, 2 dec places. I tried the .5 thing, but it either rounds it up to 1 or zeros it out.
Help.
Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[jebry]

Hi!

Set your data entry form's format for that field to percent and that should take care of the problem.

hth


Jeff Bridgham
bridgham@purdue.edu