Unable to perform a division in a calculated field

Question and answer
,
#1

Hi there,

I have a Label column, which hosts strings with the different categories and one of these categories is ‘No Label’. I want to add a calculated field that in simple words gives me the following calculation >{Labels}=‘No Label’ / total {Labels}; I tried to accomplish this with the following formula:

countIf({Labels}=‘No Label’)/count({Labels})

I tried that but of course it didn’t work and that’s why I’m here again. :sweat_smile:

#2

Hi @Marco -

CountIf expects two arguments.

countIf(dimension or measure, condition)

Try this.

countIf({Labels}, {Labels}='No Label')/count({Labels})

1 Like
#3

Thanks your help Rob, you rock! the formula worked perfectly! :raised_hands:

1 Like