Table total percentage

[MikeJones]

Hi, I have created a table and I wish to get the total %.   In Excel, the total % for the week is 6% - see below.  However, in Qlik it shows as - when I use Auto in the Totals function.  When I use Avg in the Totals function, I get 8%.  How can I get it to show 6%?

			EXCEL				QLIK
	Customers	No Access	%		Customers	No Access	%
Total	3440	214	6%		3440	214	8%	-
							AVG	AUTO
2022-11-28	741	55	7%		741	55	7%
2022-11-29	660	37	6%		660	37	6%
2022-11-30	589	50	8%		589	50	8%
2022-12-01	701	31	4%		701	31	4%
2022-12-02	680	37	5%		680	37	5%
2022-12-03	64	3	5%		64	3	5%
2022-12-04	5	1	20%		5	1	20%

Customers = if(count(Distinct{<JobType={'E','G'},[QLIK_Jobs.Client]={'XXXX'}>}if([PlannedDate.autoCalendar.Date]<Today(),[JobID-Jobid]))>0,count(Distinct{<JobType={'E','G'},[QLIK_Jobs.Client]={'XXXX'}>}if([PlannedDate.autoCalendar.Date]<Today(),[JobID-Jobid])))

No Access =if([PlannedDate.autoCalendar.Date]<Today(),count({<AbortCancelReason={"05*","06*"},JobType={'E','G'}>}AbortCancelReason))

% = No Access / Customers

[Or]

The issue appears to be that the second formula needs to be re-written with the if() contained within the count (the first formula appears to already have that in place), though it's hard to be sure given there's no sample data to check with.