Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

HC calculation

Hi amitchandak    Country Qtr Emp HC India Qtr 1 2019 Sam 234 India Qtr 1 2019 Raj 234 India Qtr 1 2019 kit 234 India Qtr 1 2019 mas 234 India Qtr 1 2019 den 234...
Need Help
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

I am sorry to have kept you waiting, here is my test pbix file:

pbix 

If my answer has solved your issue, please mark it as a solution for others to see.
Thanks!

 

Best Regards,

Giotto

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

v-gizhi-msft  I am not able to use this to calculate the %.

 

We are caculating the award % using the below Formula.

 

Awardf %= total award/ HC for that quarter,

 

But when i use the current formula i am getting wrong figure.

Please help.