You can do the multiplication in a microflow, that you trigger every time you change the number of pallets or the pallet type. An ‘OnChange’-microflow. Use the pallet type to retrieve the number of unit per that type of pallet.
Alternatively, you can add a calculation field to the orderline-entity and use the same microflow to do the math. Useful for showing that ‘number of units’ in an object on a view (datagrid, dataview, listview).
The microflow probably look something like this:
Here’s an example from one of my apps. In this decimal variable, total bottles is calculated for a shipment of cases of wine. Maybe this will help?
When trying to use these for a calculated attribute, i am getting the error that it cannot have side effects to be used in calculating a field.