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...
bhanu_gautam
Super User
Super UserAnonymous , Try using
PWD HC Goal =
SUMX(
ADDCOLUMNS(
'EmployeeTable',
"RoundedPWDGoal", ROUNDUP([Total HC] * 5 / 100, 0)
),
[RoundedPWDGoal]
)