
1. Re: Excellike equation
KK Molugu Dec 12, 2014 9:11 AM (in response to Matthew Peterson)Matthew:
Can you share some data, so someone can help you out. You need to do table calculations for that and also how the data is laid out.
..kk

2. Re: Excellike equation
Matthew Peterson Dec 12, 2014 9:33 AM (in response to KK Molugu)Hi KK. I hope this helps.
A:
IF round([random1],2) < [random1]
THEN round([random1],2) + .01
ELSEIF round([random1],2) >= [random1] then round([random1],2) end
B:
if[random2]>=0 then 1 else 0 end
C:
if[random2]<0 then 1 else 0 end
D:
if[random2]>=0 then 1 else 0 end
E:
if[random2]<0 then 1 else 0 end
F:
sum([C])/sum(([C]+[B]))
G:
if attr([A]) < .005 then [F]
elseif attr([A]) >=.005 then (([E])/([E]+[D]))
end
This is where D and E are recalculated under G to add sum(D) and sum(E), respectively.
Also, D and E are the same calculations as B and C, except they are cumulative totals.
Thanks again

3. Re: Excellike equation
KK Molugu Dec 12, 2014 9:42 AM (in response to Matthew Peterson)Matthew:
What are the Random1 and Random2 values?
..kk

4. Re: Excellike equation
Matthew Peterson Dec 12, 2014 9:45 AM (in response to KK Molugu)These are Metrics. For example, if I was doing football statistics, these would be QB rating and Yards per play.

5. Re: Excellike equation
KK Molugu Dec 12, 2014 9:57 AM (in response to Matthew Peterson)if you have that data, can you provide so we can help you out than creating the sample data.
..kk

6. Re: Excellike equation
Matthew Peterson Dec 19, 2014 7:29 AM (in response to KK Molugu)Good morning. I finally found the solution. It was simply a click of the dropdown under the measure value, compute table (down). This changed the results from what I already had to the aggregate results.
Thanks!