Syntax for ifelse summing

Question & Answer
1

Hi Community,

Its me again and this time I am stuck again while creating a calculated field.

Could someone please guide me use this overly complex tool.

image
image1132×184 3.36 KB

For the above dataset i need to create a total of values of ‘abcde’ but what I am not understanding is the how do I pass it in the ifelse statement

My current attempt is:

sum (ifelse({metric}=‘a’,‘b’,'c’sum,0))

It seems this is not working.

Could someone please help me!

Regards

2

Hi! In order to create comparison lists like ‘in’ or ‘not in’ you will need to so something like this:
sum(ifelse(Metric=“a” or Metric=“b” or Metric=“c”,Value,0))

Documentation on operators can be found here and if you scroll down to the bottom of the page you can see an example. Operators - Amazon QuickSight

Further examples of calculations using if-else logic can be found here - Ifelse - Amazon QuickSight