Contributor

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

 

 

 

1 REPLY 1
Highlighted
Super Contributor

Re: FORMULA

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'.

Screen Shot 2019-03-31 at 9.52.58 AM.pngScreen Shot 2019-03-31 at 9.49.04 AM.pngScreen Shot 2019-03-31 at 9.49.14 AM.png

 

Thanks,

LipChean