138
Hi,
I am trying to create a flowfield that takes that subtracts the value from the 'Qty on Sales Order' field from the 'Inventory' field.
Both the 'Inventory' field and the 'Qty. on Sales Order' field are from the same table.
Not sure what the CalcFormula would look like.
Any help is greatly appreciated
Thanks
You cannot subtract as part of the flowfield formulae, the only options you have is in the below url
docs.microsoft.com/.../flowfields
If you need to do calculations then you can create a calculated fields which will not be part of the table but a variable on the page and you calculate the value in the OnAfterGetRecord Trigger.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (