you can create calculated fields as follows
Count > 0.0% Flax V2 - SUM(IF [ > 0.0% Flax] THEN 1 END)
Count > 0.5% Flax V2 - SUM(IF [ > 0.5% Flax] THEN 1 END)
Then a ratio of these fileds
[Count > 0.5% Flax V2]/[Count > 0.0% Flax V2]
I attache the edited workbook.
I hope to have understood your question
% Calc TSupport_v2B.twbx 2.0 MB
Much appreciated for the assistance, you were spot on!
My understanding of configuring a calculated field has just been enhanced.
Thanx for providing yet another approach on how to resolve my challenge.
You and Mahfooj were both correct in your applications.
I have tagged Mahfooj’s answer as correct seeing that that was the first as you can appreciate.
Cheers again for the support mate!