Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I need urgent help...
i have an expression by using IF condition along with And OR operators..
Now i want to write same expression by using set analysis without using IF condition...
Original Exp:
sum(if((match(Coulmn1,01,02,03,04,05,06) and Column2 = 'Dis' or Column2 = 'Com')
and match(Column3,7,8) and OG <> ' ' and TSIT = 'Sales',Units))
So i have tried by using set analysis like below.
sum({<Coulmn1={'01','02','03','04','05','06'}, Column2 = {'Dis','Com'},Column3={7,8},OG-={' '},TSTI ={'Sales'}>} Units )
So, when i have applied this in the report values are not matching with earlier one, Can any one help me out...
Thanks in Advance
Are you sure this is the correct original expression?
sum(if((match(Coulmn1,01,02,03,04,05,06) and Column2 = 'Dis' or Column2 = 'Com')
and match(Column3,7,8) and OG <> ' ' and TSIT = 'Sales',Units))
May be you want this
sum(if((match(Coulmn1,01,02,03,04,05,06) and (Column2 = 'Dis' or Column2 = 'Com'))
and match(Column3,7,8) and OG <> ' ' and TSIT = 'Sales',Units))
Because if your original expression was correct, then the set analysis will probably need to change because it is saying
Condition 1 is true
match(Coulmn1,01,02,03,04,05,06) and Column2 = 'Dis'
or
Condition 2 is true
Column2 = 'Com'
Is that what it really is?
You can try this, if your original expression is right
Sum({<Coulmn1 = {'01','02','03','04','05','06'}, Column2 = {'Dis'}, Column3 = {7,8}, OG -= {' '}, TSTI = {'Sales'}>+
<Column2 = {'Com'}, Column3 = {7,8}, OG -= {' '}, TSTI = {'Sales'}>} Units)
Thanks for your response sunny..
Yes that is original expression...
i will try with above one.
Thank you so much sunny
It is working fine values are matching....