Sum Logic

[tmumaw]

Hello All,

Need a little help on a calculation. On one pivot table I am showing Avg No. of employees by month and year.  On the other pivot table I am showing the same data only adding Reason.  I need to show the Avg  No of employees on both tables.  I am using the same calculation on both, but the one with reason added is showing something different. Here is my calculation I use on both pivot tables.

sum({<YTDFlag = {1}>}EmpCt_ZEMPCT) / Count({<EmpDays = {1}, YTDFlag = {1}>}DISTINCT(Date_ZWKDATE))

First pivot table is by Office, Year and Month and the other is by Office, Year, Month and Reason.

[Digvijay_Singh]

I mean why TOTAL and AGGR are showing different results?

[sunny_talwar]

Have been seen this issue in some of the cases now. Not sure what causes is, but sometime it happens when there is a calculated dimension involved.

[swuehl]

May your Reason show NULL?

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others