I have the below to run and need to return a result based on clients debt to equity ratio. I have a case where the record is returning -0.6 and it is picking up the highlighted result not the first one - how do we fix this?
r360Info = zoho.crm.getRecordById("Client_Reporting",id);
if(ifnull(r360Info.get("Debt_to_Equity"),0) <= 0)
{
check1 = 0.0;
mp1 = Map();
mp1.put("Debt_to_Equity_Contribution1",check1);
updateRecord = zoho.crm.updateRecord("Client_Reporting",id,mp1);
}
else if((r360Info.get("Debt_to_Equity")
* 100) >= 195)
{
check2 = 0.0;
mp2 = Map();
mp2.put("Debt_to_Equity_Contribution1",check2);
updateRecord = zoho.crm.updateRecord("Client_Reporting",id,mp2);
}
else if((r360Info.get("Debt_to_Equity") * 100) <= 40 ) {
check3 = 155.4;
mp3 = Map();
mp3.put("Debt_to_Equity_Contribution1",check3);
updateRecord = zoho.crm.updateRecord("Client_Reporting",id,mp3);
}
else
{
check4 = 195 - r360Info.get("Debt_to_Equity")
* 100;
mp4 = Map();
mp4.put("Debt_to_Equity_Contribution1",check4);
updateRecord = zoho.crm.updateRecord("Client_Reporting",id,mp4);
}
info check1;
info check2;
info check3;
info check4;