On the face of it, the report I need to create is quite simple: amount of time in days that an RMA takes to to arrive after being issued which would normally be a simple subtraction of Received date - Issued Date.

However there is only one field where the Issued and Received information is kept {ServiceCallRMA.Action}.

Please can some one tell me how to  go about this? The way I am thinking is something along the lines of:

if  {ServiceCallRMA.Action} = "RMA Received" then A

if {ServiceCallRMA.Action} = "RMA Issued" then B

 

A-B= Amount of days.

 

As you can probably tell, I am not the most experienced