Hi all,
I have a simple sheet that shows Total Users, Conversion 1, Conversion 2 in score cards.
I've auto blended (select Conversion 1, Conversion 2, right click > Blend) the two conversion types, to give a total conversion count.
I'd now like to divide that total by the Total Users to give an overall conversion rate %.
Looking at how the Calculated Field for the autoblend has been done, it's simplu
sum(conversion1) + sum(conversion2)
with the two Score Card names highlighted in green, which I guess means its actually found those two variables / scorecards.
However, when I try to expend that...
((sum(conversion1) + sum(conversion2)) / sum(Total users))*100
quite apart from any syntax errors (its not got that far yet) it doesnt highlight "Total users" in green, and it gives an error along the lines of "Expected <something> but found "users"".
For some reason, it cant find the variable / score card name, Total users, which is literally the name of the field used in the score card?
LinkedIn
Twitter
