Skip to main content

Hi All,

I'm attempting to calculate a simple calculation from fields that already exist in a given table: 

({gross_expected_revenue_per_qty_sold} * ({your_split} / 100) * {qty_sold}) - {cogs} - ({printing_costs} * {qty_sold})
I thought I was going crazy, had two different AIs look over this, and even after that, it the formula doesn't work. 
None of the fields from which this calculation is pulling are empty, 0, or negative, and for some reason, this still throws an error when I run it. 
 
By the way, your_split is a switch formula that puts out a percentage like "35%" for example. Thanks.
Any idea what could be going wrong, here? 
Thanks!

How did you built your SWITCH() formula?

Update: just seen you have a field that outputs text "35%" instead of number. 
you should convert it to number, put 
VALUE(your_split)  instead of ({your_split} / 100)

it converts data as VALUE('35%')=0.35
btw, when your field name does not contain space, figure brackets are not mandatory.

=============
I think one or more of these fields has array type (link, lookup or multi-select). You have to convert it to number,
instead of {Field}  insert ({Field}+0)

or change the field type so it will output a number(like change to Rollup)
if my guess is not right, please provide more details, like screenshot with all mentioned fields + result field visible

Hey!

Fully aligned with @Alexey_Gusev. Please let us know if that solves the issue, or else provide further context!

Mike

Reply


Terms & Conditions