decimal calculation

Question & Answer
, , ,
1

i have a requirement, i created a parameter and i have specific values 0,1,2,3,4, i want a calculation so that if i click one it should round to one decimal like 4.1, if i click 2 it should round to 6.54, help me in this

2

Hi @rashireddy1 ,

Welcome to the QuickSight community!

For your usecase, I would write an ifelse condition to check the parameter value and then write a round() function with relevant scale value.

e.g.: ifelse(${param_name}=0, round(value_field, 0),
${param_name}=1, round(value_field,1), round(value_field,2))

Hope this helps!

Thanks,
Prantika

1 Like