Hi Experts, I am using two line items, Both line items are text format. Line item 1: FCST_1 Line item 2: FCST_2 For suppose FCST_1= 5.4591 Then By using FCST_1 we need to calculate FCST_2= 5,46(Rounded value AND instaed of dot we need replace comma) To do the requirement i write the below formula FCST 2= IF FCST_1 = 0 THEN "0" ELSE LEFT(TEXT(FCST_1), FIND(".", TEXT(FCST_1)) - 1) & "," & MID(TEXT(FCST_1), FIND(".", TEXT(FCST_1)) + 1, 2) By using above formula the result was FCST_2 = 5,45 (not a rounded figure) but we need to get a round off figure i.e 5,46 Can you please update the above formula for round the FCST_2 line item value. Regards, Uma
... View more