Calculated fields giving unexpected error

Hello Team,

When I’m trying to create a calculated field then I’m getting unexpected error and the same formulae works in other visuals:

activated_to_created: (sum(activated)*100)/(sum(created))

Hello @ravic2p , welcome to the Quick Sight community!

To troubleshoot this I would 1) refresh your session with Quicksight 2) make sure that all field names are spelled correctly and 3) try removing the parenthesis around the whole calculation. So instead you would have:
sum(activated)*100 / sum(created)

Thanks @duncan it helped, just a session refresh was required.

It’d be best if QS can update the error message on such scenario.

1 Like