Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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