Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have some data in a Sense as below.
What I want to do is when the 'Ordering Code' is empty and 'Telsims_Product_Group' contains 'LAN' or 'Telefoni', I want to add 'Broadband' for 'LAN' and 'Voice' for 'Telefoni 'in a new column (Order_new).
I have tried with and expression looking like this but it doesn't work as i want :
=if ((isnull([Ordering Code])and isnull(Product)) and (Telsims_Product_Group='LAN'),('Broadband') or
(Telsims_Product_Group='Telefoni'),('Voice'))
Any suggestion?
=if( isnull([Ordering Code])and isnull(Product), if(Telsims_Product_Group='LAN', 'Broadband', if(Telsims_Product_Group='Telefoni', 'Voice')))
Please note that if statements in general are not efficient; it would be better, after you get the function to work, to use a combination of pick match
Try this:
=if ((isnull([Ordering Code]
, If(Telsims_Product_Group = 'LAN'
, 'Broadband'
, If( Telsims_Product_Group='Telefoni'
, 'Voice'
)
)
)
=if( isnull([Ordering Code])and isnull(Product), if(Telsims_Product_Group='LAN', 'Broadband', if(Telsims_Product_Group='Telefoni', 'Voice')))
Please note that if statements in general are not efficient; it would be better, after you get the function to work, to use a combination of pick match