7 Replies Latest reply: May 23, 2017 11:17 AM by Amrit Bhagat

# Member name equals closed by Name

Hi All,

I want to show sum of only those member whose name is equal to closed by name.

Expected Output:

 Supervisor Member sum(Count) 280 GO A 10 GO B 20 GO D 30 GO E 70

Note: we can't make any changes to the script

PFA qvw for Reference

• ###### Re: Member name equals closed by Name

May be this

Sum(If(Member = [Colsed By], Count))

• ###### Re: Member name equals closed by Name

or create a flag

If(Member = [Colsed By], 1, 0) as Flag;

Supervisor, Member, Colsed By, Count

GO, A, A, 10

GO, B, B, 20

GO, D, D, 30

GO, D, B, 40

GO, E, G, 50

GO, E, F, 60

GO, E, E, 70

];

and use this expression

Sum({<Flag = {1}>} Count)

• ###### Re: Member name equals closed by Name

Thanks for the Quick reply but i also have some Set analysis written in the expression and i cant make any changes in the Script

• ###### Re: Member name equals closed by Name

Thanks for the Quick reply but i also have some Set analysis written in the expression .

like

Sum({<Supervisor= {'GO'}>}Count)

• ###### Re: Member name equals closed by Name

This

Sum({<Supervisor= {'GO'}>} If(Member = [Colsed By], Count))

or

Sum({<Flag = {1}, Supervisor= {'GO'}>} Count)

• ###### Re: Member name equals closed by Name

Thanks a lot

• ###### Re: Member name equals closed by Name

How you are expecting 280 for Total Sum?? Is that is type error