cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to make the aggregate computation for pick values fields

Highlighted
Participant

How to make the aggregate computation for pick values fields

How to make the aggregate computation for pick values fields.

 

I am trying to make the computation for the sum(+) of a few pick values, i will choose few Story sizes(mentioned in the below command) the addition should able to see in the other field.

Facing eeror on below computation

 

aggregate("Sub Story", sum("Story Size"=="Very Tiny [1]"?1Smiley Sad"Story Size"=="Tiny [2]"?2Smiley Sad"Story Size"=="Very Small [3]"?3Smiley Sad"Story Size"=="Small [5]"?5Smiley Sad"Story Size"=="Modest [8]"?8Smiley Sad"Story Size"=="Medium [13]"?13Smiley Sad"Story Size"=="Large [20]"?20Smiley Sad"Story Size"=="Very Large [40]"?40Smiley Sad"Story Size"=="Epic [100]"?100:0))))))))))