I have two fields in the RLI that I need to multiple together into a separate field.
I currently have Unit price £ and quantity, so I need to multiply the unit price by the quantity.
e.g unit price is £5.00 x quantity of 4 = £20.00
all your help is very appreciated in advance
Hi Jaymie Raymond,
The formula you would use in field would be:
multiply($unit_price_field_name, $quantity_field_name)
One thing to note here is that this is assuming that British Pound is your default currency. If it is not the default currency, you may need to adjust your formula to get the right calculation in British Pounds.
You can find a full list of Sugar Logic formulas in the documentation.
Chris
Hi Jaymie Raymond,
The formula you would use in field would be:
multiply($unit_price_field_name, $quantity_field_name)
One thing to note here is that this is assuming that British Pound is your default currency. If it is not the default currency, you may need to adjust your formula to get the right calculation in British Pounds.
You can find a full list of Sugar Logic formulas in the documentation.
Chris
