Hi In this example: [Untitled] I would like a calculation to SUM values with colour = green (24), then I would like a separate calculation to sum values where colour is NOT green (106). I plan to use this as part of a drop down selection control; ifelse( ${colourpicker} = 'green',<calculation …

Use this formula ifelse(color=${colorpicker},value,NULL) ifelse(color<>${colorpicker},value,NULL)

Calculated field - sum one column based on another as part of a control

Sapna November 10, 2021, 9:03pm 2

Use this formula

3 Likes

Topic		Replies	Views
Syntax for ifelse summing Question & Answer calculations	1	2927	July 10, 2022
Alternative to "contains" for multiple choice parameter in controls Question & Answer quicksight , filters-controls-and-parameters , Business-Intelligence-Engineer	2	37	September 27, 2024
Calculation based on met value within a field Question & Answer error , calculations	1	460	October 17, 2022
sumOver and sumIf Question & Answer sum , calculations	1	2469	October 25, 2022
Summary of conditionally formatted table field Question & Answer how-to	3	263	February 10, 2023