In the following Sales Order Line page, I have a calculated field “Amount”. I find option to calculate the amount field by embedding the formula in Amount field as follows:
MULTIPLY(pageVars.quantity, pageVars.price)
Or
when the record is created as follows:
However, the amount field remains empty.
Try wrapping them into NUMBER(pageVars.quantity)
.
You’re using a form to input data so it could be treated as a string until you change it.
2 Likes
This worked for me.
It looks like you are trying to do the calculation as you create a record and commit the data to the database. So, you won’t see it in the amount field on the screen.
- Create 2 Page Variables for Price and Quantity
- Add your two input fields and assign them to the page variables
- Create an Amount field that multiplies the 2 page variables:
- See the amount field: