Skip to main content

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

IF(FIND('GH', {Type}),SUM({Paid (Sold)})*.1)

IF(FIND('GH', {Type}),SUM({Paid (Sold)})*.1)


Thank you!!!


Lol man I feel stupid now… IDK why I didn’t think about that.

Reply


Terms & Conditions