
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 27, 2024 07:47 AM - edited ‎Oct 27, 2024 07:57 AM
Hi All,
I'm attempting to calculate a simple calculation from fields that already exist in a given table:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 27, 2024 08:37 AM
How did you built your SWITCH() formula?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 27, 2024 08:41 AM - edited ‎Oct 27, 2024 01:45 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 28, 2024 12:44 PM
Hey!
Fully aligned with @Alexey_Gusev. Please let us know if that solves the issue, or else provide further context!
Mike
