Why does my derived measure result as a string?

[SunnyD]

Hi,

I'm very new to Looker and can't seem to figure out why the following LookML results as a STRING. How do I change it to be an integer or number value? I would like to create a custom table calculation but it won't do anything as it's a string. I'm sure this isn't the first time this has been posted - 1 million apologies 🙂 

measure: Agency_Revenue_Planned_rec {
group_label: "Plan"

sql: sum(${TABLE}.Agency_Revenue_Plan_rec)/count(${TABLE}.Agency_Revenue_Plan_rec) ;;
value_format_name: usd_0

}

[thuykly · Accepted solution]

Hi Sunny, I believe you need to set the type as something like 'sum' or 'count' or 'average' etc. See examples in the Looker docs https://cloud.google.com/looker/docs/reference/param-measure-types