Hi, when you say that the average call column is a calculated column, what do you mean exactly?
Is it a post-aggregation calculation? Isn't that the source of your issue in the total?
The average you calculate by hand is a post - post-aggregation average and maybe OBIEE is just doing a post-aggregation average (so changing the order of the calculation) ?
Would be good if you can have a look at the SQL to find out exactly how OBIEE can have 123, it will help you in fixing it.
OBIEE-jeopardy: "What's the diff between pre-agg (physical formulas in RPD column) vs post-agg (derived logical columns or Answers calcs?"
*Actually average call is a calculated column that is depend on another two columns col1 and col2 , these are added in INCLUDE columns Average call= col1/col2
*My issue is in Grand total on running values
*For pre and post aggregation, can you give answer the Berg question because i also don't know about these.