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