Divide 2 calculated fields in QuickSight derived from same column xyz

Hi Team,

I am trying to divide 2 calculated fields in QuickSight derived from same column xyz.
i.e. fields1/fields2 but it fails without saying anything about error. My intention is to derive percentage from those 2 fields.

Note : I could have used countIf but seems it doesn’t support condition with empty string condition

Many Thanks!


Could you provide us an example with dummy data and the calculations that are being done ? A screenshot of the error would also be helpful.


1 Like


Can you please share the calculations used in field1 and field2. This should help us understand what the problem could be…

Hi @bipshik. We have not heard back from you regarding your question. We would still like to help. If this is no longer relevant after seven days, we will archive this question.

Hi Team, thanks for the response, i was able to figure out myself and we can close this. Division was problem as numerator and denominator were at different LAC

1 Like

@bipshik Glad you found the solution! Thanks for letting us know.

May I know what is the solution?

Hi! Will you please share the solution?