PN:CPI calulation in lesser decimals.
When we calculate CPI rent increase, the CPI index values are entered in the index history and the rent increase is done by the method: current index- previous index/ previous index. The percentage value is multiplied with the Rent amount to get the monthly rent increase amount.
Here, oracle calculates the index values with 7 decimals and the user calculates index with 4 decimal places. This brings up a change in the rent amount. How can we decrease the decimal calculation to 4? is it possible? Any workaround?
Your help is much appreciated.
Thanks
Alex