Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a summing up issue!!!
I have a selector box of values 1 – 12 (periods)
Loaded into qilkview I also have days per period i.e. period 1=31 days, period 2=28 days ,period 3=31 days etc…
What I’m trying to achieve is to sum the daysPerPeriod depending on the periods selected (or even better to remove user input and to sum the total days for the total periods currently available for the max year)
I’ve tried hardcoding the year and periods available into a variable to pull back the total days but get crazy numbers.
What I really want to do is to sum(daysPerPeriod) where Year = max(Year) and Period = total periods available for year selected
any help greatly appreciated
daysPerPeriod | Year | Period |
---|---|---|
31 | 2012 | 1 |
38 | 2012 | 2 |
31 | 2012 | 3 |
30 | 2012 | 4 |
31 | 2012 | 5 |
30 | 2012 | 6 |
30 | 2012 | 7 |
31 | 2012 | 8 |
i should add that i've tried this hardcoded
=Sum({<Staff.Academic_Year={$(vYear)},Staff.Academic_Month = {$(vMaxPeriod)} >}
Number_of_Days_in_Period)
Try this
Sum({$<Staff.Academic_Year={"$(=Max(Year))"},Staff.Academic_Month={''}>} No_of_Days_in_Period)
See attached qvw