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.