technically the "numbers" in the category buttons are not numbers but text. For using them as real numbers you must parse the text to number. This should work:
Number(@C1 - ...) + Number(@C2 - ...) etc.
Help with Calculations of Categories with numbers in the buttons
Hi ... How could I sum the C1 to C5 values in these buttons? I know to to sum number fields, but not category fields.
Thanks in advance for any help!
Please sign in to leave a comment.
I run a search on this forum, and I found this https://help.podio.com/hc/en-us/community/posts/360047956311-Using-a-calculation-field-to-convert-text-in-a-category-field-to-a-number-to-be-counted-in-a-later-step
But I tried to run the code and it didn't really work ... any idea of how I can convert these buttons to number to be used in later steps.
And I also tried a second approach ... using IF ELSE ....
But none of them worked ...
Thanks a lot
Hi Rainer, thank you! Such a simple solution! I wish Podio had a better documentation for calculations. Their PDF has been the same for more than 4 years. Thank you!!!