create 3 calculates:
1 field - accept
if status = 'accept' then number of register end
2 field - new
if status = 'new' then number of register end
sum (accept) / sum (new)
Without looking sample data or workbook I'd like you try something like this,
SUM(IF [Status] = 'Accept' THEN [Number of Records] END)/SUM(IF [Status] = 'New' THEN [Number of Records] END)
SUM(if status = "Accept" then [number of Records] end)/SUM(if status = "New" then [number of Records] end)
The above calculation will do
Hope this helps
Plz mark this answer as correct/helpful to close the thread
Sorry it has taken me so long to respond to this. For some reason I cannot get this calculation to work, it is just returning blanks.
The packaged workbook is attached. I am working off the Conversion (2) tab and the new field I created based on the above is "Calculation 1".
ATTACHMENT REMOVED AFTER CORRECT ANSWER WAS RECEIVED
Wow! That did the trick....why does that work? (so I can learn )
For the below logic, when [Status Type1]= 'Accept' then [Number of Records] else NULL.
So, When you are wrapping this logic to sum , it will try to [Number of Records] with null, and NULL operation with any value is null.