Number Format

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

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.')

Re: Number Format

sunny_talwar — Tue, 07 Feb 2017 23:12:00 GMT

Try this:

='Revenue Per Employee: '
&
Num(Sum({$<HCOEdetail={'Revenue'}>}Actaul_Amount)/Sum(EjFTE), '$#,##0.00')