RE: Formula Reference
I have a sublist called Expense and another called Item. Both contain fields called Amount. I’m trying to implement another field and insert a formula referencing Amount from the Expense sublist because when I do {amount} / {quantity} it does not work at all so I believe due to conflict. How do I reference the one from Expense thanks
| In general, the quantity column in not available at expense sub-list.
You should use a formula (numeric) field with this formula – for purchase order transaction. case when {item} is NULL then {amount} else round((nvl({quantity},0)-nvl({quantitybilled},0))*nvl({rate},{amount}),2) end This formula is a good reference to start with. |
On the purchase order form, there is the Amount in the Item subtab and Expense subtab. I created the Quantity field and PPU field and I want the PPU field to return the price per unit by dividing the {amount} / {quantity}
OK, regard the items subtab it should be fine just make sure to use this formula {amount}/NVL({quantity},1) to avoid dividing with zero. Regards,the expense subtab you don’t have a quantity column to calculate your PPU. Would you like that the PPU will be calculate only for the items subtab?
Based on the Expense subtab. Because both of them have the amount field. Thanks
As I said before your formula will not work properly at the expense subtab because you don’t have a value there for the quantity. Hence the PPU field won’t work there.
battk
What transaction are you working with? It sounds like you are working with a vendor bill and the expense sublist of a vendor bill does not have a quantity column.
Coder
Purchase Order
Coder
On the purchase order form, there is the Amount in the Item subtab and Expense subtab. I created the Quantity field and PPU field and I want the PPU field to return the price per unit by dividing the {amount} / {quantity}