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

Question & Answer
, ,
1

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 here>,
${colourpicker} = 'not green',<calculation here>,

NULL

)

I played around with SUMIF but this appears to not sum / sum everything.

Thanks!

2

Use this formula

  1. ifelse(color=${colorpicker},value,NULL)
  2. ifelse(color<>${colorpicker},value,NULL)
3 Likes