Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to edit the following expression to include "Sum({<[Year]={$(=(Only(Year)))}>}(Actaul_Amount)) "
Sum({$<HCOEdetail={'Revenue'}>}Actaul_Amount)/Sum(EjFTE)
How do I combine these so that it filters the year and the revenue divided by FTE?
Try this?
Sum({$<HCOEdetail={'Revenue'}, [Year]={ $(=Only(Year)) } >} Actaul_Amount)/Sum(EjFTE)
Try this?
Sum({$<HCOEdetail={'Revenue'}, [Year]={ $(=Only(Year)) } >} Actaul_Amount)/Sum(EjFTE)
Hold on why you want the expr Only(Year) in your set. You expr of sum/sum(fte) will be calculated based on your selections right? What is that you are trying to get ?
It's a line graph with selected year and previous year for the two lines. Your solution worked. Thank you very much!