Calculative Field examples (admin)

Created by Mark Eves, Modified on Tue, 26 Apr, 2022 at 4:00 PM by Mark Eves


='Planning Application '||{PLANNING_APP_REF}||''



 



This should look like "Planning Application Hello" in the form



 



---



 



='Total Amount: £'||(NVL({ITEM_CODE},0)*5.89)



 



Text, followed by a pulled-through value on a previous page, multiplied by 5.89



 



If the value is 2, it should look like "Total Amount: £11.78" in the form



 



---



 



=({ITEM_CODE_1}) + ({ITEM_CODE_2})



 




Scenario: A customer selects a value for the item with code "ITEM_CODE_1", and a value for the item with code "ITEM_CODE_2". The system will add these values together.



 



---



 



=((NVL({ITEM_CODE_1},0)) + (NVL({ITEM_CODE_2},0))



 




Scenario: A customer selects a value for the item with code "ITEM_CODE_1", and a value for the item with code "ITEM_CODE_2". The system will add these values together. However, this will only occur if a value is selected for either item. If no value is selected for either item, it will denote "0" for that particular item.



 



---



 



Calculative Fields for Products?



 



Add a Product item. Underneath that, add a Hidden item. Set the default value to #PRODUCT_PAYMENT_GRAND_TOTAL#



 



=((NVL({P_PP_AMOUNT},0)) + (NVL({BIN_SIZE_AMOUNT},0))



 



This will add the Product value pulled through on the Hidden item to the Select List item.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article