savings” message. Let’s say your sale price is in an attribute called
$itemstoreprice, and the regular price is $itemretailprice. The formula
for percent savings is:
100 * (1 – $itemstoreprice/$itemretailprice)
Here’s the result for an item that’s marked down to 14.99 from 19.99:
25.0125062531266
Well, that’s kind of ugly. Maybe I only want whole numbers. That’s easy to
do with the FORMATNUMBER function:
FORMATNUMBER (100 * (1 – $itemstoreprice/$itemretailprice), “F0”)
That “F0” means to output a Fixed number of digits to the right of the
decimal; in this case, zero digits.
And here’s the result: 25
If you wanted two digits to the right of the decimal instead of “F0” you’d
have “F2” and the result would be 25.01.
Let’s stay with “F0,” and some text:
CONCATENATE (“Save “, FORMATNUMBER (100 * (1 –
$itemstoreprice/$itemretailprice), “F0″),”% off retail!”)
Here’s the result:
Save 25% off retail!
Blogpost by Anthony Alford: The Feed Doctor
