Help with expression

[Anonymous]

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

[Gysbert_Wassenaar]

=sum({<opp_create_year={$(vCurrentYear)}, opp_type = {'Monthly'}>} opp_count)

[Clever_Anjos]

=sum({<[opp_type]={"Monthly*"},opp_create_year={$(vCurrentYear)}>} opp_count)

[Anonymous · Accepted solution]

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)

[MarcoWedel]

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