Dear Experts,
In Excel, value of formula can keep 9 digits in left of decimal, while in BPC it only keep 7 digital.
So, in Input Schedule, value ( calculated by excel forumula ) will be sent again to BPC (because of digits), even there's no change in Input Schedule.
For example: In BPC
Total Value : 10592256.0805757
Percentage: 1%
in BPC, Amount = Total Value * Percentage = 105922.56080580
in Excel, if I use formula: Toatal Value * Percentage , value of the cell will be 105922.5608057570. Since value of the cell is not equal to value in BPC, it will be sent again.
Are there any ideas on avoiding data sent again? Since there's are lots of cells with formula, I don't want to use Round() in formula.