0 votes
1 view
in BI by (15.1k 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 (41.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
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...