Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sum({$<PT = {'MD'}>}(NP - OP)*OH)
In the above expression how can I add if SK = '5073', '5118' then divided OH by 2 else OH
May be this
Sum({$<PT = {'MD'}>}(NP - OP) * If(Match(SK, 5073, 5118), (OH/2), OH))
May be this
Sum({$<PT = {'MD'}>}(NP - OP) * If(Match(SK, 5073, 5118), (OH/2), OH))