AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

5K members online now
Discuss regaining access to Analytics accounts, restoring accounts, changing user access levels, and navigating the homepage
Guide Me

Formula not working in Universal Analytics Calculated Metrics

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



I'm trying to create a formula in Calculated Metrics that is (Goal 10 Completions * (a whole number)) - Cost. 


This is how it's formatted:

( 10 * {{Event - Account Sign Up (Goal 10 Completions)}} ) - {{Cost}}


I tried setting the Formatting Type to Float, Integer, and Currency (Currency being the desired) and none will return the appropriate results. 


Any idea if there is something that can fix it or if there's a limitation, what that limitation is?



1 Expert replyverified_user

Formula not working in Universal Analytics Calculated Metrics

Top Contributor
# 2
Top Contributor

Hi Lisa, 



this may be a case where your formula is correct but the metrics you selected for the formula do not mix with the dimension you're applying it to.

In which report do you intend to use it?

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan