This expression is suppose to give me the sum of the interval Where Hierarchy Level 1 ='Business' and also in case a different hierarchy is selected, then IT will show the sum of interval for all the Document numbers that are common between Hierarchy level 1 = 'Business' and that selection.
This works fine, untill I make a selection. Suppose I select a hierarchy level 2, then the values OF Text boxes showing Hierarchy level 1 data becomes '0'. while the data for Hieararchy level 2, Hierarchy level 3 and 4 are showing correct.
Similarly when I select a hierarchy level 3, then the values OF Text boxes showing Hierarchy level 1 and Hierarchy level 2 data becomes '0'. while the data for Hieararchy level 3, Hierarchy level 4 are showing correct. and so on.
These hierarchies are different fields of the same table. There are four hierarchies, Hierarchy Level 1,2,3,4. There are hierarchies in which are not depended on one another, but enen then these have Document numbers that fall uner each of them most of the times. I am trying to create a \sample data. will update once it is done. It is a bit difficult.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.