Jul 03, 2019 01:33 PM
I have a multi select menu for each job, and so each job may or may contain the GH option, by itself, or with other options.
I am trying to calculate Commission on jobs that CONTAIN GH.
The way I have it now, it only returns commission based on jobs that are ONLY GH.
Any help would be appreciated. Thank you!
IF(Type = “GH”, SUM({Paid (Sold)}*.1))
Jul 03, 2019 02:19 PM
IF(FIND('GH', {Type}),SUM({Paid (Sold)})*.1)
Jul 03, 2019 02:30 PM
Thank you!!!
Lol man I feel stupid now… IDK why I didn’t think about that.