Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Afternoon,
I'm trying to get this number to only show two decimal points. With the following expression statement the number is showing as "55555.555555555"
='Revenue Per Employee: '
&
Num(Sum({$<HCOEdetail={'Revenue'}>}Actaul_Amount),'$#,##0.')/Num(Sum((EjFTE)),'$#,##0.')
Try this:
='Revenue Per Employee: '
&
Num(Sum({$<HCOEdetail={'Revenue'}>}Actaul_Amount)/Sum(EjFTE), '$#,##0.00')
Try this:
='Revenue Per Employee: '
&
Num(Sum({$<HCOEdetail={'Revenue'}>}Actaul_Amount)/Sum(EjFTE), '$#,##0.00')