calculating measure based on dimension's field

[ziabobaz]

Hello,

I have Status as Dimension and Clicks as Measure.

I need to calculate CR% Measure = Click / Clicks <view_site>:

When I try to build a straight table with the following formula:

CR% =

     sum( clicks) /

     sum( {<status={'view_site'}>} clicks),

It returns:

What is the correct way to make it happen?

Thank you!

[agigliotti · Accepted solution]

maybe this:

sum( clicks) /

sum( {< status={'view_site'} >} total clicks)

[ziabobaz]

of course, you are right, I forgot about 'total' )

thank you!

[agigliotti]

great!

you are welcome.