I'm trying to calculate a percentage in a text object field.
So far, by using the bellow expression I was able to get the result I want, but it gives me the full % value. But what I really need it a round number with no decimals, or max two decimals numbers.
My values are:
Total (CC + Other) = 87
My expression is:
=count(if([Tipo de contacto]='CC',[Tipo de contacto]))/count([Tipo de contacto])*100 & ' %'
Value gotten so far: 79,310344827586 %
I'm looking for an expression that gives me something like: 79% or 79,31% (with only two decimals)
Many thanks for your help.