Skip to Content
0
Former Member
Feb 23, 2011 at 04:53 PM

9 digits in left of decimal, while BPC only keep 7 digital

87 Views

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.