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
Go to Solution.
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'.