cancel
Showing results for
Did you mean:
Not applicable

## set anylsis question

Hi all.

have a table having employee_no and bill

employeenobill
6123200
4252450
SUP-GK-452250
4535400
SUP-GK-333350

actualy SUP-GK-452 and SUP-GK-333 are code for retired employees.

I want to show the sum in graph only those employee who are not like 'SUP%' in one graph and

only for those who are like 'SUP%; in another graph.

how can i do this through setanylsis.??

1 Solution

Accepted Solutions
Partner - Champion

Hi,

Try with this expression

Sum({<employee_no-={'SUP*'}>} bill) for not 'Sup%'

Sum({<employee_no={'SUP*'}>} bill) for 'SUP%'

Hope it helps

Celambarasan

5 Replies
Partner - Champion

Hi,

Try with this expression

Sum({<employee_no-={'SUP*'}>} bill) for not 'Sup%'

Sum({<employee_no={'SUP*'}>} bill) for 'SUP%'

Hope it helps

Celambarasan

Specialist

Hi,

Use the expression like,

not like 'SUP%'  = if(left(employeeno,3) <> 'SUP',Sum(bill))

like 'SUP%'  = if(left(employeeno,3) = 'SUP',Sum(bill))

Regards,

Iyyappan

Luminary Alumni

Hi,

Try this

not 'Sup%' =Sum({<employee_no-={'SUP*'}>} bill)

'SUP%'=Sum({<employee_no={'SUP*'}>} bill)

Hope it helps you.

Regards,

Jagan.

Not applicable
Author

hi...

you can use

"=Sum({1<Emp_NO={"SUP*"}> }Bill)"   for SUP*

and

=Sum({1-\$<Emp_NO ={"SUP*"}> }Bill)

for other

Thanks and regards

Arun Goel

Not applicable
Author

thnks sir..

its really works

Community Browser