How To Calculate a Price Discrepancy Expressed As a Percent?

JustinC · 2020-05-25T22:22:07.445Z

Hello all,

I have a baseline number value, and I’m trying to calculate the difference between the Sold price and the Listed price for a Thing.

Does anyone know how to set this up or store these values so that the calculation can be expressed as a percent (%)?

ambroisedlg · 2020-05-26T12:25:35.459Z

Hi @JustinC

I’m not sure what you’re asking. From my understanding both Sold Price and Listed Price are fields in the DB right? Which one does the baseline number value represent?
Do you want to display the % value between those two values? Do you want to store the % value in the DB?

JustinC · 2020-06-01T15:41:45.355Z

What I needed was to ‘Calculate percentage change’ between one price to another.

i.e. the list price or the sale price.

The percentage change can be plus or minus by a % off of the original.

This helped me so maybe it will help someone else - https://www.skillsyouneed.com/num/percent-change.html

system · 2020-08-03T22:31:41.939Z

This topic was automatically closed after 70 days. New replies are no longer allowed.