Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am not sure if this type of solution already exist. But any insight would be of great help if not discussed already in the forum..
Problem Scenario:
I have sales and customer table and there are few records which has sales but no customer data. Now on front end, i need to filter out on particular customer record which is also resulting in filtering out the sales for null customer record. I need the sales for null customer part of total sales .
Hi
Can you provide sample data n expected result to achieve? If my understanding correct, if you want to display the null customer info for selection, you can try like below
NullAsValue CustomerId;
Set NullValue = 'NULL';