Hi!
I'm trying to do this calculation to get "hours worked" is what percent of "Budget" , but it is not giving me the expected results.
Thanks in advanced!
2 answers
@Mayra Arango
Hi, in this case you can use:
100*SUM([Hours worked])/SUM([Budget hours by department(P)]
I guess you are trying to use it as a percentage, so I would remove the 100:
SUM([Hours worked])/SUM([Budget hours by department(P)]
And in the data pane, right clic on the calculation, select default properties, format, and in the dialog choose percentage.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
