Skip to main content

Simple Calc Function Won't Work, Please Help!

  • October 27, 2024
  • 3 replies
  • 33 views
T
Forum|alt.badge.img+7

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!

3 replies

Databaser
Forum|alt.badge.img+25
  • Databaser
  • Brainy
  • October 27, 2024

How did you built your SWITCH() formula?

Jan - Databaser
Alexey_Gusev
Forum|alt.badge.img+25

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

Mike_AutomaticN
Forum|alt.badge.img+28

Hey!

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

Mike

Terms & ConditionsAccessibility statement