Generate a Number from Another Number and a % Value

[psk180590]

Hello All,

I have the following requirement

Actual Value	%	Desired Value	Difference
800	80 %	1000	200
100	83 %	120	20
7	70 %	10	3
5	50 %	10	5

I would like to generate 'Desired Value' and  'Difference' using Actual Value and %

TIA

Sai.

[tresesco · Accepted solution]

It seems to be a simple math, like:

Value*100/PurgeChar(Percent, '%') as Desired