#8 Formating values in age pyramid

This age pyramid shows positives values on both side of 0. Strange no ?

Not really since you can force format number with the Num() function

❓ How To ❓
Use this expression as a measure for your chart :
Num(Sum(EmployeeCount),'0;0')

"0;0" First part before ; is the format for positive, the right is for negative

Not really a secret, but good to remember no ?

Download QVF

DQC8.jpg