Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Luca

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question