Use a Formula within a Formula

[tconnery]

I've created a few formulas and now require a field that uses some of the existing formula values in a calculation.

Is there a way I can create a new formula similar to the following:

 

[@field:Formula1] / [@field:Formula2]

Reference: http://howto.caspio.com/tables-and-views/data-types/formula-fields/

"Other Formula Fields Not Compatible"

 

Hoping for a way around this....

Thanks

[Mathilda]

11 hours ago, tconnery said:

I've created a few formulas and now require a field that uses some of the existing formula values in a calculation.

Is there a way I can create a new formula similar to the following:

 

[@field:Formula1] / [@field:Formula2]

Reference: http://howto.caspio.com/tables-and-views/data-types/formula-fields/

"Other Formula Fields Not Compatible"

 

Hoping for a way around this....

Thanks

Yes, there is a workaround. You can perform this calculation in a calculated field on a report datapage

[tconnery]

Yes, thank you Mathilda. I spoke to a Caspio resource who also pointed me in this some direction after I posted to the community. Perhaps someone else will run into this and this post will help them.

[NailDyanC]

Hi, just to update this post and add in the previous comment above. Yes, by default we cannot call a formula field inside a formula field however you can copy the whole formula that you have in your other formula field so that it can still perform the calculation that  you would like. For example:

Formula 1:

[@field:field1] + [@field:field2]

Formula 2:

[@field:field2] + [@field:field3]

In your other formula field you can use the following formula;

([@field:field1] + [@field:field2]) / ([@field:field2] + [@field:field3])