example:

action closure is 31-3-2012 2:40:27 AM

action pending-closure is 28-3-2012 4:18:27PM

 

i want to calcuate the diffenece between the closure and pending to closure actions

 

i tried this but it didn't work:

 

(if {act_type.act_type_sc} = ["closure"] then {act_reg.date_actioned}) - (if {act_type.act_type_sc} = ["pending-closure"] then {act_reg.date_actioned})

 

**act_type.act_type_sc is the action type short code which can be closure, pending-closure

**act_reg.date_actioned is the datetime in which the action was taken

 

please help.