Generalized Formula

[tulsi]

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?

[PattemManohar]

@tulsi Please provide sample data and expected output.

[tulsi]

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.

[tulsi]

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.