Pivot Table not showing the correct Percentages against Totals

[xlSb]

Hi,

I'm trying to calculate the percentage for each row (Hour) by column (Day) where the column (Day)percentage should total 100%. But I'm running into an issue where the row total doesn't sum upto 100%. I feel like it has something to do with zero divide by zero. I have tried multiple methods where I have used, if(isnull()), alt(), if( not isnull()) etc

[jmmolero]

could you show the measure expression?

[xlSb]

sure - =(if(Source=1,count(DISTINCT %Customer)/count(total<Day> DISTINCT %Customer)))

[jmmolero]

Did you try with set analysis?:

count({<Source={1}>}DISTINCT %Customer)/count({<Source={1}>} total<Day> DISTINCT %Customer)

[xlSb]

Hi, yes I have also tried with Set Analysis. Below is what the output looks like.

[Brett_Bleess]

I would recommend reviewing the following Design Blog post regarding Rounding errors, believe that will likely explain things:

https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

Regards,
Brett