Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Mothly info
May be like attached
May be like the attached
=Year([KPI Date])-1
& '/' & Year([KPI Date])
I suggest creating this in the script....
Thanks - but how ever i would be more interested to get the current fin year than all the years in the filter
and also if i click on 2017/2017 it shows only 2017 data excluding 2016 data
FilnYear Filter box should have only 2016/17 - field( next year 2017/18, later 2018/19...)
Would you please suggest
I am not sure I completely understand... You need 2017/2017 or 2016/2017?
sorry it was my typo in the last post:
I need 2016/17 in the finyear list box and if i select that the data should have only for 2016/17 data- excluding all the years selections
Hope its a bit better now
May be like attached
thanks - but cant we done the same in the application side ?
May be using triggers, but why do you want this to be done on the front end? It would be complicated, whereas script based solution is simple and efficient?