Expression

[sona_sa]

Hi 

I have a list box, where, Now I want on selection of that list box value, Value should to display in text box, If there is no selection then Total Sales value should to display in Text Box.

For example, I am using 3 text box to display IT SALES, SCM SALES, FINANCE SALES, But If I select IT, Only IT related sale to display in IT SALES Text BOX, another two box will be 0.

If There is no selection, By default all value will display accordingly.

Thanks.

[yilmazmurat]

Try this one 

IF(GetFieldSelections(Year)='IT_SALES',SUM(SALES),0)