Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)
How to return rows with not null values from fields? My data source has offers for market on weekly basis, which contains order with different discounted products and quantity taken. i want to show orders with customer phone numbers.

Order id                  Phone
1                         

2                         xxxx-xxx-xxx

1 Answer

0 votes
by (47.2k points)

Hi Vaibhav,

You can add a calculated field to get the id whose value is not " " , then can form a group. Now show the orders for that product.

IF ISNULL([Phone No]) THEN "0"
ELSE [Order Id]
END


Now it might work.

Hope this helps you.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...