Why the avg per day is not correct

[mahnoor1279]

Why the below table where the avg per day expression is same but shows different sum  for each dimension.

Count({<Flag={'Form','Account_Opening'}>} [REVIEWED_BY])
/
Count({<Flag={'Form','Account_Opening'}, DATE={"=WeekDay(DATE) <> 'Sat' and WeekDay(DATE) <> 'Sun'"}>} DISTINCT (DATE))

[Vegar]

The expression is not giving you the total on each row because it is taking the dimensions into consideration.  The counts will only be done on transactions that matches the table dimensions.

To get a total value, the same on each row, use TOTAL in your aggregation function. 

Count( {<your set criterias>} TOTAL YourField)