Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a static KPI that doesn't change when any filters are used throughout my app,
reading around it looks like the key is using {1} but I'm evidently not getting it in the right place as it's not working!
Current format is as below which returns a null when a filter is selected:
1-
((Sum({1}{$<TdateYear={"(=$(vCurrentYear))"},NPD_Other={'Overhead'}>} Nmhrs))+ (Sum({1}{$<TdateYear={"(=$(vCurrentYear))"},NPD_Other={'Overhead'}>} OThrs)))/
((Sum({1}{$<TdateYear={"(=$(vCurrentYear))"}>} Nmhrs))+ (Sum({1}{$<TdateYear={"(=$(vCurrentYear))"}>} OThrs)))
Thanks Marcus - why would the rangesum give me a different result to my original total ?
By combining values with the normal math operators each non-numeric result for one of them will produce NULL for the entire calculation-level. The range-functions instead handle each non-numeric parameter as ZERO. Within the most scenarios is this type of error/exception-handling more suitable and expedient as getting NULL.