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))