Formula with Count function in Script

[chandra63]

Hi,

Need urgent help here.

Hope All doing good

I am having a scenario like below by using the field OD_Details 

Total_OD = count (OD transactions (OD_detail=”OD”)) +count (recovered transactions (OD_detail=”Recovered”))

Total_recovered = count (recovered transactions (OD_detail=”Recovered”))

Total non OD= Non OD transactions (OD_detail =”Not OD”)

In the OD_Details field. I am having values 'NOT OD', 'OD' and 'Recovered'

By using that values  we have to create three fields Total_OD, Total_recovered and Total non OD as shown  in Above

we create like below.

load  link_Cust_Cont_Mort,   

     Count(OD_Details='OD')+count(OD_Details='Recovered') as Total_OD,

     Count(OD_Details='Recovered')+count(OD_Details='NOT OD') as Total_Recovered

Resident Transaction1  Group by link_Cust_Cont_Mort;

But it is not looking fine.

How we can achieve

Thanks In Advance.