HI vpidala,
Why you trying to divide by 100 the result of the Variance Percent Formula? It shouldn't be needed, as it is handled by the predefined function. Have you tried removing it?
Thank you Aformenti for quick reply. it is existing formula, it been there for last few years. I removed the divided by 100, still the same issue. how to predefine the dividing?
Actually, I am guessing that the error is because of this formula. can you please suggest how to back track to find out the exact interaction or calculation that causing this issue.
I am not following.
The syntax on the new Formula you sent is wrong, you do not need the Divide Function there. Your original formula looks correct:
api.Data.GetDataCell("VariancePercent(A#AVG_Daily_Sales:T#POV:U8#None,A#AVG_Daily_Sales:T#POVPrior12:S#Actual:U8#None)/100")This is wrong:
api.Data.GetDataCell("(VariancePercent(Divide(A#AVG_Daily_Sales:T#POV:U8#None,A#AVG_Daily_Sales:T#POVPrior12:S#Actual:U8#None)),100)")The issue you having must be somewhere else, unfortunately without more info its difficult to assess.
I have cube view with below POV:
cube name: Planning
Flow member: EndBal
Origin memeber: Top
IC Member: Top
UD1: reporting layer
UD2: total dpt
UD3: total prj
UD4 .... UD8: None
while I am opening cube choosing one of the entity hierachy then the issue pops up saying that "" Value was either too large or too small for a Decimal.""
while I was checking the endbal BR then I thought that the issue arrised beacuse of this BR. With this scenario,
what are the possibilities of checking to narrow down the issue?