Edit Expression

[fanninam]

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?

[vishsaggi · Accepted solution]

Try this?

Sum({$<HCOEdetail={'Revenue'}, [Year]={ $(=Only(Year)) } >} Actaul_Amount)/Sum(EjFTE)

[vishsaggi]

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 ?

[fanninam]

It's a line graph with selected year and previous year for the two lines.  Your solution worked.  Thank you very much!