This content has been marked as final. Show 3 replies
I am trying to add an expression to a chart that calculates null values with a particular activity type. I have it working with the expression below:
However, I want it to calculate this only for an activity that is an OPD. E.g:
=NULLCOUNT(IF(ACTIVITY_SUB_TYPE = 'OPD', SALESPARTDESC).
This also works but is still calculating the null values for all other activity sub types and not only OPD's. It will only show if I select OPD. (which is frustrating)
Any advice will be greatly received. Thank you.