Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community.
I am building a Key Performance Indicator in a text box and I want to set some parameters on the value shown (%).
If no Year is selected in the listbox available, I want the KPI to show this years current status, if a year is selected I want the KPI to be the selected years status.
This is my expression:
=If(IsNull(GetFieldSelections(Year)),( ((Sum([FDJ Final S/O])/Sum([FDJ Final NTEI]))*Sum([FDJ Final NTEI]))/sum([FDJ Final NTEI]) and Year=Year(Today())) )
But I am getting a zero value. Without setting the Year, I am getting an average of all years.
Any help rendered will be valuable.
Thanks!
May be try this
=If(GetSelectedCount(Year) = 0, ( ( ( Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final S/O])/ Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI]) ) * Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI]) ) / Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI]) ),
( ( ( Sum([FDJ Final S/O])/ Sum([FDJ Final NTEI]) ) * Sum([FDJ Final NTEI]) ) / Sum([FDJ Final NTEI]) )
)
May be try this
=If(GetSelectedCount(Year) = 0, ( ( ( Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final S/O])/ Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI]) ) * Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI]) ) / Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI]) ),
( ( ( Sum([FDJ Final S/O])/ Sum([FDJ Final NTEI]) ) * Sum([FDJ Final NTEI]) ) / Sum([FDJ Final NTEI]) )
)
Thanks Sunny. That worked as a charm.
I appreciate the speedy reply.