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
if I understand try (put in a texbox to see the result)
=WildMatch(GetFieldSelections(CM_Month, '@'), '*12*')
or
=WildMatch(Concat(CM_Month, '@'), '*12*')
instead of
GetFieldSelections('Month', 12)
in your expression
i did try to use this expression
=If((GetFieldSelections(Center)='RO' and PD='other' and CM_Month='12'),(sum(Forecast)+100),Sum(Forecast))
but the issue is when i try to multi pick the month values like 10, 11 & 12 the expression doesn't work the way needed.
Now, the issue have been narrowed down to when i multi pick the month or when ever the month field value has a 12 then for PD=other there should be +100, how can i do this?
IF(GetFieldSelections(Center)='RO' and PD = 'other' and GetFieldSelections(CM_Month)=12, SUM(Forecast)+100,SUM(Forecast))
if I understand try (put in a texbox to see the result)
=WildMatch(GetFieldSelections(CM_Month, '@'), '*12*')
or
=WildMatch(Concat(CM_Month, '@'), '*12*')
instead of
GetFieldSelections('Month', 12)
in your expression
Hello Dinesh,
Try this expression.
=if((GetSelectedCount(CM_Month) > 1 or CM_Month='12') and PD='other',SUM(Forecast)+100,SUM(Forecast))
Hello Manish, but this doesn't work if i multi pick like months=10, 11 and 12. This only works when my selection is just for the month=12 only.
Does the attached help
So, the requirement is probably not
month=12
but
month 12 is in selection.
If yes, this would work:
=If((Center='RO' and PD='other' and index(GetFieldSelections(CM_Month),12)>0),(sum(Forecast)+100),Sum(Forecast))
Hi,
Checked enclosed file it is working as per your requirements.
use this expression
=If((Center='RO' and PD='other') and WildMatch(Concat(CM_Month, '@'), '*12*'),(sum(Forecast)+100),Sum(Forecast))
Regards,
IF(GetFieldSelections(Center)='RO' and PD = 'other' and Index(GetFieldSelections(CM_Month),12)>0, SUM(Forecast)+100,SUM(Forecast))