Value and Total value in the ser

[#1]

Hi - I am trying to get % of total goals as additional column. I am trying to get the sum of total count using below expression, but I am not getting the exact total value. Am I missing something here?

({<GOAL_MEM_RNK={1}, GOAL_COMP_DT ={"=Len(GOAL_COMP_DT)>0"} >} {1} Rnk)

[#2]

correct expression:  SUM({<GOAL_MEM_RNK={1}, GOAL_COMP_DT ={"=Len(GOAL_COMP_DT)>0"} >} {1} Rnk)

[#3 · Accepted solution]

What does the field Rnk represent? Is there a reason you cannot use Sum(TOTAL Cnt) from your table above?  But perhaps I am oversimplifying your issue.

[#4]

Thanks Rebecca. Adding TOTAL solved this problem..