Use a Formula within a Formula

[tconnery 0]

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 66]

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 0]

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.