Can't divide, please help

How can I divide column expenses by column total leads? I try (expenses / total leads) but it won't work.15.10.2024_10.45.37_REC.png

0 1 218
1 REPLY 1

Hi @Aliaksei, thanks for your post!

It looks like Total leads is a metric (an aggregated value) and Expenses is a dimension (a non-aggregated field). You can't perform calculations between a field that is an aggregated value and a field that is a non-aggregated value. 

As. workaround you can try making Expenses a metric and then dividing the two fields, as described in this Reddit post.