What I am trying to do is calculate a prognosis based on dividing Sum of PaidOutAmount by the # of day this month and then multiply by the Max Amount of Days This Month.
Here is a picture of the Budget Table:
So for today (02.2012.2016) it would be:
(Sum(PaidOutAmonut) / (Value which is on that row from "DagDenneMåneden"))
Max(DagDenneMåneden) - (Value which is the highest this month from "DagDenneMåneden)
Now what I am trying to understand is how can I get the value which is on the row in "DagDenneMåneden" from Todays date so that the prognosis grows as this increases? Monday the value would 3 instead of 2 and prognosis would be adjusted accordingly.
(Sum(PaidOutAmount))/Max(DaysThisMonthUntilThisDate] )* Max ([DaysThisMonth)
My issue is that I don't know how to get the value which is the highest # of days on the current day (today) into the expression. The only field I have is DaysThisMonth but if I use the Max for that it would be.
(Sum(PaidOutAmount) / 22)
the correct calculation would be (for todays date)