How to get average of progress percentage

Questions & Answers
1

Dear All
i had a case where i did not know hot to calculate average from progress percentage coloumn. thank you

percentage
percentage746×333 17.2 KB

2

Hi @Rahmatdinur,

The Total row tries to be intelligent and either calculate the sum of values in the row or % from the totals in other columns (you can check what values do the measures you use in the percentage calculation have in the Total row).

There is an option to override the Total row calculation with the CASE condition based on the Total row name. Please try the following.

CASE WHEN [Issue].CurrentHierarchyMember.Name = '$total_aggregate'
THEN
  Avg(VisibleRowsSet(),
    -- your previous Progress Percentage formula here
  )
ELSE
  -- your previous Progress Percentage formula here
END

Lauma / support@eazybi.com