topic Re: Combine AND and OR in an expression in App Development

Combine AND and OR in an expression

stekol61 — Fri, 21 Feb 2020 14:17:00 GMT

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?

Re: Combine AND and OR in an expression

Gysbert_Wassenaar — Fri, 21 Feb 2020 15:59:34 GMT

Try this:

=if ((isnull([Ordering Code]
    , If(Telsims_Product_Group = 'LAN'
        , 'Broadband'
        , If( Telsims_Product_Group='Telefoni'
            , 'Voice'
        )
    )
)

Re: Combine AND and OR in an expression

lorenzoconforti — Fri, 21 Feb 2020 15:59:53 GMT

=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