How to implement this condition :
=IF(warranty_status='OW' AND rescheduled_reson='Repair' and status_remark<>'Telephonic Resolution' and Remark='Y',JobsheetAMC,NULL())
in this expression for KPI:
=(Sum(recived_amt)+sum(transport_cost)-sum(if(DuplicateFlagpart='1',0,ReturnedPrice))-sum(discount))
/
(sum(if(DuplicateFlagService='1',0,service_charge_c))
+
sum(if(DuplicateFlagpart='1',0,price*comsumed_qty))
+
SUM(received_amt_c)
+
if(is_installation='1',sum(num#(installation_charge_c)),'0')
+
sum(transport_cost)
+
sum(other_charge))