Divide 2 calculated fields in QuickSight derived from same column xyz

Question & Answer
, , ,
#1

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!

#2

Hi,

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.

Regards,
Koushik

1 Like
#3

@bipshik,

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

#4

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.

#5

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
#6

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

#7

May I know what is the solution?

#8

Hi! Will you please share the solution?