3,225
How would i make this calculated field for our orders?
I need to make a "subtotal to ship" field by taking the extended price of all items that will be shipped less the extended price of backordered items. I would like this to show on the Order before we transfer it to invoice.
Thanks for any help.
Katie
*This post is locked for comments
Hi Katie
There are two methods.
The first is exactly as Justin describes.
The other is to make a single calculated field with the calculation
(Qty Fulfilled * Unit Price) - (Qty to Back Order * Unit Price)
Then drag the field into the footer and set it for type SUM.
This is simpler and will give the same figure.
David
Hi Katie,
The approach I suggest is to create 3 calculated fields.
1.) Presumably take the Qty Fulfilled * Unit Price. (Let's call this CALC1). Place it in the Report Footer and change the "Display Type" to SUM.
2.) Presumably take the Qty to Back Order * Unit Price. (Let's call this CALC2). Place it in the Report Footer and change the Display type to SUM.
3.) When creating this 3rd calculated field, make sure you have "Resources" set to "Report Fields". Now when you click on the "Field" drop down list, you should see: RF_SUM CALC1 and RF_SUM CALC2 (Because you placed a field in the "RF" section, made the Display Type = "SUM" and the field was called CALC1...hence RF_SUM CALC1, etc...)
So the expression for this 3rd calculated field would simply be: RF_SUM CALC1 - RF_SUM CALC2
Place this 3rd calculated field in the RF section of your report and change the "Display Type" to Data.
============================================
The above is just a suggested method, and you may want to use different fields in Calc1 and Calc2. The "Tricky" bit (or the bit I think most people forget about) is in CALC field 3 where you use the "Report Fields".
Thanks,
Justin
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (