New to Qlick: trying to create a calculated formula.

[Neil2]

Hello, I'm trying to count the total number of round and count the total numers of deviations inside those specific rounds. then multiply the total number of rounds by 100 and devide them to the total number of deviations. 

i'm trying to create a percentage of deviations of the total numbers per round, could you please help me?

This is what i have so far, but this is not working.(i want to show it in percentage so thats why i divide it by 1 instead of 100)

COUNT(DISTINCT {<[Antwoord afwijking] = {1}, [Is CCP Check Flag]= {1} , Year= {"$(=Max(Year))"} , [Inspectie CCP]= {"Monitoring"}>} [%KEY_Beoordeling])
*1
/COUNT(DISTINCT {<[Is CCP Check Flag]= {1}, Year= {"$(=Max(Year)))"}, [Inspectie CCP]= {"Monitoring"}>} [%KEY_Beoordeling])

[TcnCunha_M]

COUNT(DISTINCT {<[Antwoord afwijking] = {1}, [Is CCP Check Flag]= {1} , Year= {"$(=Max(Year))"} , [Inspectie CCP]= {"Monitoring"}>} [%KEY_Beoordeling])
/

COUNT(DISTINCT {<[Is CCP Check Flag]= {1}, Year= {"$(=Max(Year)))"}, [Inspectie CCP]= {"Monitoring"}>} [%KEY_Beoordeling])

then in the formating field add as %