Skip to main content
1-Visitor
June 12, 2019
Question

How to make the aggregate computation for pick values fields

  • June 12, 2019
  • 0 replies
  • 861 views

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]"?1:("Story Size"=="Tiny [2]"?2:("Story Size"=="Very Small [3]"?3:("Story Size"=="Small [5]"?5:("Story Size"=="Modest [8]"?8:("Story Size"=="Medium [13]"?13:("Story Size"=="Large [20]"?20:("Story Size"=="Very Large [40]"?40:("Story Size"=="Epic [100]"?100:0))))))))))