expression to be calculated based on the selections

[#1]

Depending upon particular selections i want to add $100 to the Forecast column. Selections that need to be are

Center='RO'

PD='other'

month=12

then sum(forecast) +100 else sum(forecast)

having little bit of difficulty implementing this in the expression so i made a prototype to mimic my requirement.

Thanks in advance.

PFA

[luisvalenzuela]

Hi try this,

=RangeSum(

  if(

  SubStringCount(Concat(Center, '|'), 'RO')>=1 and

  SubStringCount(Concat(PD, '|'), 'other')>=1 and

  SubStringCount(Concat(CM_Month, '|'), '12')>=1,100,0

  )

  ,

  sum(Forecast)

)

Regards