Hi, I have events which contain 3 Fields: "StartDate", "Value_per_month" and "Nr_of_Month". They basically disclose some monthly financial flow which beginns at "StartDate" and ends after "Nr_of_Month". The goal is to show a sum of "Value_per_month" for each month over all events. In most cases the dates are in the future, so it will be a bit tricky to get this to work. However, at least a table view would be great and use some basic vizualisation on top. I thought I could create fields for each month, for example "value_yyyy-mm" and assign the value to each and then sum up the values in each field accross all events. However I have not found a way to do this dynamically in a loop for X times, based on variable "Nr_of_Month". I have checked combinations of eval, makeresults, foreach, gentimes, etc. Any basic idea how to approach this would be welcome. Many thanks in advance
... View more