Forum Discussion
Divide one column by another split by distinct column
CTR is a measure or calculated column?
try with adding Calculate Function.
CTR=Calculate(divide(sum(data[Clicks],sum(data[impresions]))
Regards
Victor Velarde
Looks right to me. Double check everything to make sure the formulas are right etc
Sorry realise I need to provide more context.
Here is a smaller subset of the data and I will want to calculate the Click-Thru-Rate (CTR) (i.e. CTR = Clicks / Impressions)
However, I cannot get the formula of CTR at the total correct either through this method:
Or this method:
Any reason why this happens?
CTR is a measure or calculated column?
try with adding Calculate Function.
CTR=Calculate(divide(sum(data[Clicks],sum(data[impresions]))
Regards
Victor Velarde
Sorry you are right! Made a mistake that it should be a measure not calculated column. Thanks!
