Forum Discussion
SUM rounded numbers
I need to adjust my pwd calculation By law here in my country, factories need 5% of employees to be pwd. Until then the formula below was working normally, and everyone was happy: PWD HC Goa...
You need to force the total to work out the rounding at the factory level. You can do that with something like
Round Up =
SUMX ( VALUES ( 'Table'[Factory] ), ROUNDUP ( [Total HC] * 5 / 100, 0 ) )