FORMULA

HI Experts,

 

We have line items 

Line item:1 :   FCST_1

Line item:2 :   FCST_2

 

based on FCST_1 convert into Rounded value.

Capture.PNG

 

Both line items are text format.

 

First item data in dot(".") format but we need to convert comma(",")

And we need round off the FCST_1 line item.

 

For suppose FCST_1 = 1.2498   then by using some formula we need to convert into 1,25.

 

Hope you help on this

 

Regards,

Uma

 

 

 

Best Answer