Forum Discussion
Generalized Formula
Hi,
I have to calculate accuracy which in my case is ((Actual Rounds- Expected Rounds)/(Actual Rounds))-1. I have a column for actual Rounds. The way I calculate Expected Rounds is I multiply it with the number of jobs*TierRound. This TierRound is also a column that exists in my table.Number of jobs I calculate by using count(Job Number) . Can anybody help me with this?
3 Replies
- tulsi Please provide sample data and expected output.
The table looks like this. I have created a measure for Total jobs= count(Job Number). I have to get Rounds accuracy, so the accuracy for 4 tiers will be different. Expected Rounds is Total jobs*Rounds. I tried to create a calculated column but there's an error saying there's a circular dependency.
For example if Tier 2 has 20 jobs then expected rounds= 20*2
Tier 3 has 40 jobs then expected rounds=40*3
Tier 4 has 60 jobs then expected rounds= 60*4.
You can ignore the tier Round column. For tier 1 expected round count is 1, tier 2 is 2 tier 3 is 3 and tier 4 is 4.
To get expected rounds we have to mulitply number of jobs in that tier * expected round count.
