Creating a new field by using invoice number and bill amounts

Question

i have

[AR_Current_Sum_of_Bill_Amount]+[A_R_31___60_Days_Sum_of_Bill_Amount]+[A_R_61___90_Days_Sum_of_Bill_Amount]+[A_R_91___120_Days_Sum_of_Bill_Amount]+[A_R_121___150_Days_Sum_of_Bill_Amount]+[A_R_151___180_Days_Sum_of_Bill_Amount]+[A_R_181___365_Days_Sum_of_Bill_Amount]+[A_R_366___730_Days_Sum_of_Bill_Amount]+[A_R_731___1000_Days_Sum_of_Bill_Amount]+[A_R_1001___1500_Days_Sum_of_Bill_Amount]+[A_R_Over_1500_Days_Sum_of_Bill_Amount]

these fields to add and fall under new field created for the respective invoice in the file.

How to write the logic for this in formula tool to create the new fields for each invoice should see the bill amount

need help on this?

jdminton · Answer

The quotes around the formula will turn it into text. The error is where it tries to convert to an integer. Remove the quotes for the formula.

binu_acs · Answer

@sathyaKPMG remove the " from the formula also make sure that all the amount fields are double

sathyaKPMG · Answer

Added the snaps. And based on the invoice how should i can add the values .

Error.docx