FORMULA

UMAMAHESH

HI Experts,

 

We have line items 

Line item:1 :   FCST_1

Line item:2 :   FCST_2

 

based on FCST_1 convert into Rounded value.

 

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

 

 

 

LipChean_Soh

Hi Umamahesh,

 

As a rule of thumb, don't use 'Text' format to store numbers. You might not 'feel' the effect with a few test data sets. But once the data grows, the performance of the entire model will DEFINITELY become bad.

 

Do try the following. Note the 'Decimal Point'.

 

Thanks,

LipChean