Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table and a listbox with year and 1 with month selection.
I would like to see data in my straight table from the month I selected and all the previous months.
Is this possible. Because now if I select an Year and Month I only see the data from that month.
Regards,
Kris
Ah, my mistake. You also need to 'reset' the selection in the other fields:
sum({<Year=,Month=,MyDateField={'<=$(=max(MyDateField))'}>} Amount)
You don't need your variable vMaxDatum. Simply use $(=max(MyDateField))
It should be easy if you also have a date field. You can use set analysis to show the data from the selected month and previous months: sum({<MyDateField={'<=$(=max(MyDateField))'}>} Amount)
a Date range selection(with min max dates) may help you regarding your problem.
Thank you Gysebert for your reaction.
But as you can see in the screenshot I only see values of the selected month in my straight table.
The variable (vMaxDatum) is calculated as
=num(makedate(if( GetSelectedCount( _CalYear) > 0, _CalYear, max(_CalYear)) , if( GetSelectedCount( _CalMonth) > 0, num(_CalMonth), max(_CalMonth)) , if( GetSelectedCount( _CalDay) > 0, _CalDay, max(_CalDay))))
Ah, my mistake. You also need to 'reset' the selection in the other fields:
sum({<Year=,Month=,MyDateField={'<=$(=max(MyDateField))'}>} Amount)
You don't need your variable vMaxDatum. Simply use $(=max(MyDateField))
Thank you!
Now I see it, it is indeed logical.