Thanks for ur response. Actually i do not have 2 different fields. I have one field serial no . I want to calculate the serial no repeated in the backend because i want to categorize this like
if once repeated as spare call
2nd repeated as additional spare
3rd time non spare etc.
Is it possible to do could u pls help on the same??
thanks for the response,
I do not 2 fields here to calculate, I have only 1 field serial no. I need to write this in backend because i need to calculate the ratio of repeated calls. I want something like this
if call is repeated for first time- 'Spare'
if call is repeated for second time- additional spare
if call is repeated for third time- it is a non spare
can u pls help me on this???