Two Condition in Text Object Expression

[#1]

Dear all,

I have the following code in the expression..

= SUM({$<b_UserDeptSection={'MACHINE LINE'}>} b_IndirectHours)

What is the best method to select the userdeptsection = 'NON MACHINE LINE' as well? My current solution as below

SUM({$<b_UserDeptSection={'MACHINE LINE'}>} b_IndirectHours) + SUM({$<b_UserDeptSection={'NON MACHINE LINE'}>} b_IndirectHours)

May i know is the SUM function will take in 2 condition for example (b_UserDeptSection= {'MACHINE LINE'} or b_UserDeptSection= {'NON MACHINE LINE'})??

Thank you

[MayilVahanan · Accepted solution]

Hi

Try like this

= SUM({$<b_UserDeptSection={'MACHINE LINE', 'NON MACHINE LINE' }>} b_IndirectHours)

Hope that helps

[#3]

Thanks Mayil.

What about the 2 condition referring to different field?

one is b_UserDeptSection='MACHINE LINE'

and

b_UserAge>18

how do we put in a single SUM statement?

[#4]

Hi,

= SUM({$<b_UserDeptSection={'MACHINE LINE'}, b_UserAge ={'>18'}>} b_IndirectHours)

[MayilVahanan]

Hi

Try like this

=SUM({$<b_UserDeptSection={'MACHINE LINE'} , b_UserAge ={">18"} >} b_IndirectHours)

Hope that helps