Rounding issue in BPC

[vamshib01]

Hi Experts,

I am trying to allocate a quantity from ALL_PRODUCTS to base level based on an allocation % that is calculated in different step. The allocation % is 4 decimal places and the quantity to be allocated is 5 decimal places. The output of both is more than 7 decimal places in some instances and because BPC has a limit of 7 decimal places, the output gets truncated as seen in Column F. There is a difference between Total Qty to Qty allocated. Even though in this example it is very negligible, in the grand scheme of things, it adds up to a 1000 difference thereby having to manually adjust it into a different account. Did anyone have this problem and what did you do ?

[former_member186338 · Accepted solution]

You have initial value in PS_ALLPLAN and allocated values in BAS(PS_ALL):

*XDIM_MEMBERSET PRODUCT=BAS(PS_ALL)
*XDIM_ADDMEMBERSET PRODUCT=PS_ALLPLAN
*XDIM_MEMBERSET ACCOUNTGM=Gallons
*WHEN PRODUCT
*IS PS_ALLPLAN
*REC(EXPRESSION=%VALUE%,ACCOUNTGM=DIFFACCT)
*ELSE
*REC(EXPRESSION=-%VALUE%,ACCOUNTGM=DIFFACCT) //Minus value!
*ENDWHEN

P.S.

*REC(EXPRESSION=-%VALUE%,ACCOUNTGM=DIFFACCT,PRODUCT=PS_ALLPLAN)

To have difference on single product...