Hi all,
I have a data set which has total number of transaction that is basically Number of records & a column which has there success tagging (0 is success, 1 is failure)
I want to calculate there success rate which is "Total Number of successful transaction/Total number of transaction", similarly for failure
for example : my total count is 100, but my count for '0' tagging is 40, (so i want 40/100)*100
2 answers
hi Abhishek,
So to do this you can 'embed' the Tagging = 0 into the formula at row level...so would be
SUM(IIF([Success_Tagging] = 0,1,0))/SUM([Number of Records])
Hope that makes sense
