AnsweredAssumed Answered

Down total disappear with distinct count

Question asked by bideveloper_2019 on Dec 5, 2019

Hi,

We are using Board 11.1 cloud right now.

I calculate Head count in the Bi weekly pay period. But the hourly employees get payment weekly, so I have to use Distinct count AGGREGATION Function as follow, but the down total disappeared as yellow highlight as follow:

If I don't use Distinct count AGGREGATION Function regarding This Period Head Count, the down total appeared as follow, Previous Period down total still disappeared with Distinct count. But the number of This Period Head Count  is wrong because of some duplication.

 

I want to know if I did something wrong? Is there a way to figure it out?

 

Thanks for help!

 

Bing

Outcomes