Getting Average of Future Data

[Legacy 389185]

Hello everyone, I have a list box which contains data like;

---

From	To	Product Type	2015Price	2016Price	2017Price
York	Center	A	50	100	40
York	Center	B	50	20	70
Center	York	B	20	50	80
York	Center	B	40	30	50

<tbody>
</tbody>

So through a new record button, I'm able to add new rows and data to this list and I'm also able to filter this data. When I type 'B' in my filter product type text box, the list only shows the rows with product type B.

So I need 3 text boxes which should show me the average for 2015, 2016, 2017 Prices but it should show it only for the visible rows. For example if I don't write anything in filter text box, these average boxes should display the averages for all rows but if I filter by product type B, it should calculate and show the price averages for all product type B which means 3 rows. Also if I filter by from York to Center and Product Type B, it should calculate just for 2 rows because 2 rows will be displayed because of the filter.

Another problem is, since I'm able to add new rows, the system should be able to put it in the average calculation. For example if I add another row like this;

York

Center

B

20

30

50

<tbody>
</tbody>

and when I filter like YORK CENTER and Product Type B, it should calculate the average for 3 rows since 3 rows will be displayed.

Can you help me with that?

 

[Micron]

Since you are able to filter the data for the listbox, use the same filter criteria in a DSum expression for the calculated control. Look here under Domain Aggregate Functions.

 

[Legacy 389185]

Thanks mate I'm working on it