Assign a null field to a variable
Dear Community first of all thanks for the support that you provide with this network.
I have a little but important problem: in brief i need to calculate a compliance about one field. If this field is compliant then i assign 0 otherwise 1. This calculation is made in a formula and it works. The problem is that if the TYPE of the field is XX i do not need to calculate this compliance but anyway i need to count how many instance of this type i have for each customer.
In brief if in the selection criteria i exclude the type XX the compliance calculation works but i do not count the XX type because are excluded.
If in the selection criteria i consider the type XX and even if i add a proper if statement before calculating the compliance, at the end the variable is 0 and it affect the overall compliance calculation.
I think that my solution is to assign a NULL value to the variable in case the TYPE XX is reached but i can not
Thank you very much
Hoping my description is clear