Calculations based on criteria
I have a system that is used to plan future operations, as well as to data from view old ones.
I now want a page that will do calculations on the operations performed, such as total revenue, average revenue and so on and so forth. However, it is of course only supposed to use data from the finished operations in the calculations, and not the future ones.
I'm having a bit of trouble setting this up, as my first thought of using a portal with a filter doesn't quite seem to be working.
Does anyone have a good suggestion of how this is accomplished the easiest way?