Aggregate decimal values

Hi there,

I have dimension type: number with decimal values. I had created measure to call this dimension. Now I need to display these values as below mentioned format
0.18
0.08
0.45
0.45

and need to do aggregation (average on top of it). But its not calculating after decimal values, expected result is 1.16 instead resulting 0 which is not the appropriate solution.

dimension: YYY{
type: number
sql: ${TABLE}.“TABLE”*1.0000 ;;
value_format_name: decimal_2
}
measure: ZZZ{
type: number
sql: AVG(${YYY}) ;;
}
Kindly provide solution.

Thanks in advance.