When creating a new task, we have 2 custom fields which are check boxes to capture when someone was the primary person organising a sales meeting on the secondary person organising the meeting. We then tried to make a report (not saved search) that added up for each sales person the number of EITHER primary or secondary meetings they attended, we are looking to do this for current month, past month and past year.
Problem - I can successfully do this report and filter by the primary meeting checkbox, but I need to add together how many primary + secondary meetings the sales person has had.
Possible solution that's not working yet!
- I've created a custom crm field for the task form - I'm aiming to use this as the filter on the report by getting the field to equal 1 if either the primary or secondary meeting checkbox is ticked.
- under validation and defaulting I checked 'formula' and then put this formula in OR({custevent17},{custevent5}) - I was hoping that if either meeting checkbox is ticked then this field would return true and then I could wrap an if statement around it to make it equal 1 (possibly not needed) eg
IF(OR({custevent17},{custevent5}), 1,0) - not sure of the exact syntax, this is excel style.
- then in the report filter I could say give me all tasks where this new CRM field equaled 1.
My OR formula doesn't work and I get "ERROR: Invalid Expression"
I'm also not sure if I need to tick 'store value' or not for this new CRM field - I'm guessing not but I could be wrong.