Thanks Lee for the nice explanation, but for me it doesnt work. In my case the TransationStatus field is text based and i want to calculate what was the percentage of Successful transaction out of total.
SuccessRate= Round(SUCCESS/(SUCCESS + FAILURE)*100 , 2)
The method you mentioned doesnt work for me. It is always showing 0.