You’re offline. This is a read only version of the page.
585
I created a Calculation in SmartList Builder and here is the formula:
{Sales Transaction Amounts History:Extended Price} /{Sales Transaction History:Subtotal} *{RM Apply History File:Write Off Amount}
Based on my example, it will be 25/225*$5 = should be $.056 if rounded off instead of $0.55.
Do you have any idea how I can get the rounding off?
Thanks,
Cecile
*This post is locked for comments
Hi Mike,
I tried it but didn't work. Any other thoughts?
Thanks,
Cecile
While I haven't attempted this, have you tried:
ROUND(({Sales Transaction Amounts History:Extended Price} /{Sales Transaction History:Subtotal} *{RM Apply History File:Write Off Amount}), 3)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
