How to write code for Median

[Scldb]

I have a column that I what to show a negative number.
The equation for this is:
Unit Price % = ([Proposed Price]-[Current Price])/[Current Price]

With Numbers it would be:
Unit Price % = (378.62 - 382.44)/382.44

Which is -1%
But Access shows 0.00%

Can I please get help. Thank you

[ADezii]

I have a column that I what to show a negative number.
The equation for this is:
Unit Price % = ([Proposed Price]-[Current Price])/[Current Price]

With Numbers it would be:
Unit Price % = (378.62 - 382.44)/382.44

Which is -1%
But Access shows 0.00%

Can I please get help. Thank you

Format((378.62 - 382.44)/382.44, "Percent")

OUTPUT:

-1.00%

[Scldb]

Format((378.62 - 382.44)/382.44, "Percent")

OUTPUT:

-1.00%

Sorry, I forgot to tell you this part. The equation that I'm trying display will be on a table. I created the table, now I'm using an update query to update that column into a percentage of the equation. Every row will have different numbers, but utimately, the equation should be the same. I have the proposed price and current price on this same table and every row has different proposed prices and current prices - hence the "([Proposed Price]-[Current Price]/[Current Price])" equation.

What you gave me "Format((37 8.62 - 382.44)/382.44, "Percent")" throws an error when I try to run the update query. So you have another suggestion?