Post

2 followers Follow
0
Avatar

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!

 

Michael Spanholi

Please sign in to leave a comment.

3 comments

1
Avatar

Hi Michael,

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. 

Rainer

Rainer Grabowski 1 vote
Comment actions Permalink
0
Avatar

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

Michael Spanholi 0 votes
Comment actions Permalink
0
Avatar

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!!!

Michael Spanholi 0 votes
Comment actions Permalink