Question: Can anyone help write this equation: Insert another calculated field named % Difference that subtracts the Purchase Price field amounts from the Current Value field
Can anyone help write this equation:
Insert another calculated field named % Difference that subtracts the Purchase Price field amounts from the Current Value field amounts, and then divides the result by the Purchase Price field amount.

The equation should reflect the following values, I just can't figure out how to write the formula.

I've already tried the following INCORRECT formula:
=(('Current Value'-'Purchase Price')/'Purchase Price')%
=(('Purchase Price'-'Current Value')/'Purchase Price')%
Romano Collectibles Sum of \% Difference 93.17%40.80%21.62%23.97%137.80%44.50%Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
