can anyone write it in report studio sql way
this is an accces query
Split: IIf([Detail no VIN]![Year_Month]>"200207","Able to Charge Back",IIf([Unit Vin]![REGULAR_PMT]=0,"Able to Charge Back",IIf(([Detail no VIN]![TOTAL_PAYMENT]/[Unit Vin]![REGULAR_PMT])>11.99,"No Charge Back","Able to Charge Back")))
my answer seems to give only the "able to charge back"
thi is is mine
case
when [2c_reserve_detail].[Year_Months]>'200207' then 'Able to Charge Back'
else (case
when [3_vin_detail].[Scheduled Payment Amount]=0 then 'Able to Charge Back'
else(case
when [2c_reserve_detail].[Total Payment]>11.99 then 'No Charge Back'
else 'Able to Charge Back'
end
)
end
)
end
plz help!!!!thanks in advance
Looks like you forget to divide by [Unit Vin].[REGULAR_PMT] in the report Studio SQL ..