Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))