EXPRESSION HELP

[sona_sa]

Hi,

I have a list box, Field Name is Department. I am counting Head Count of Department Wise and Displaying in 3 Different Text Box.

Expression : 1. Count ( if (Department = 'SALE', HeadCount) for First Text Box. 2. Count ( if (Department = 'IT', HeadCount) for Second Text Box. 3. Count ( if (Department = 'FINANCE', HeadCount) for Third Text Box.

All three Text Box output is correct, Now Suppose if I select from Department List Box --> SALE, So Only First Text Box Value should to display. Another Two Text Box Value will be 0.

Whatever selection I am making from Department List Box, Only those text box value will display, rest text box value will be zero.

How I can make this expression.

Thanks.

[rwunderlich]

Do you want all three boxes to display values, even when selections are made in Department?

Sum({<Department={'SALE'}>}HeadCount)

Sum({<Department={'IT'}>}HeadCount)

Sum({<Department={'FINANCE'}>}HeadCount)

-Rob

[sona_sa]

Yes it is like that but but when I will select from List box Department, Like Sales, So Sales department Head count will display in Sales Test Box, but another two text box value will be zero.

I hope u got my point.

[sona_sa]

I am using the same, But when I am selecting from List Box, I am getting all the value in 3 Text Box.

I want if I select from List Box IT, IT value will display in IT Text Box, and Another two will will zero.

Thanks.

[rwunderlich]

Forgive me, I'm not understanding if you are describing what is happening or what you want to see happen. What do you want to see when you select IT from list box?