Use formula result for next formula

[DeKleineBoer]

Hello,

I am trying to make an auto calculation for 2 different customer groups. I have a formula installed to calculate my purchase price inclusive vat from my purchase price excl vat. From the result of this formula I want to calculate the price +10% and the price +40%.

How can I do this?

[SinJunYoung]

Hi @DeKleineBoer, can I get an example out of this? Can you provide me an example equation so I can visualize?

[CoopperBackpack]

Hello @DeKleineBoer,

As far as I understand, you are trying to make calculations on the table level using the Formula field.

If so, I am afraid, that it is not possible to use the result of some formula in another formula directly (selecting the field with formula when clicking the picker icon).

In such cases I usually duplicate the required formula in the next calculations.

For example:

1) You have the "Price_with_vat" Formula field with the following syntax [@field:Price]*1.2

2) You need to calculate the  price +10% from the "Price_with_vat" field. The formula should be ([@field:Price]*1.2)*1.1

Hope this helps.

[TellMeWhy]

Just to add, if you have conditions for your calculations (ex. add 10% if price < 50 and add 40% if price > 50), you may use CASE WHEN Function to set up your conditions. 

You may refer to this HowTo Article for more details about function reference: https://howto.caspio.com/function-reference/. The CASE WHEN is under MISCELLANEOUS FUNCTIONS AND EXPRESSIONS section