Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Please can you help me put the two expressions below into one.
=sum(If(WildMatch([opp_type],'Monthly*'),opp_count))
=sum({<opp_create_year={$(vCurrentYear)}>} opp_count)
I cannot seem to figure this one out !
Thanks
May this is what you want:
=sum({<opp_create_year={$(vCurrentYear)}>} If(WildMatch([opp_type],'Monthly*'), opp_count))
or
=sum({<opp_create_year={$(vCurrentYear)}, opp_type={'Monthly*'}>} opp_count)
=sum({<opp_create_year={$(vCurrentYear)}, opp_type = {'Monthly'}>} opp_count)
=sum({<[opp_type]={"Monthly*"},opp_create_year={$(vCurrentYear)}>} opp_count)
May this is what you want:
=sum({<opp_create_year={$(vCurrentYear)}>} If(WildMatch([opp_type],'Monthly*'), opp_count))
or
=sum({<opp_create_year={$(vCurrentYear)}, opp_type={'Monthly*'}>} opp_count)
Hi,
other solutions could be:
=Sum(If(opp_type like 'Monthly*' and opp_create_year=$(vCurrentYear), opp_count))
or
=-Sum((opp_type like 'Monthly*' and opp_create_year=$(vCurrentYear))*opp_count)
although set expressions should perform better.
hope this helps
regards
Marco