Sales $$ are being feed from an api to contacts, these contact are assigned owners. The report is a created based a field which is automatically populated from the api, we have a dashboard based on this report. The salesteam have the ability to monitor thier year to sales based on this report. Management has asked I manually subtract a certain specific number which will be specific to the user (aka contact owner). I was thinking about doing a IF statement - If(owner, Bill then ytd gross - 1000000) which would mean that current YTD sales number would have $1mm subtracted from it.
You could add a custom field to the User record and then add each specific value to that field as a negative and then use that in the formula to calculate your new Sales ##.
