Forum Discussion

vpidala's avatar
vpidala
New Contributor II
7 months ago

Value was either too large or too small for a Decimal.

Dear Team, while opening the cube view, I am experiencing issue " Value was either too large or too small for a Decimal."  I can see that in BR for EndBal, one of the divided formula caus...
Admin
aformenti's avatar
aformenti
Contributor II

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. 

 

 

 

vpidala's avatar
vpidala
New Contributor II
7 months ago

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?

 

  • aformenti's avatar
    aformenti
    Contributor II
    7 months ago

    Hi vpidala,

    Could you try with this:

    api.Data.GetDataCell("Divide(VariancePercent(A#AVG_Daily_Sales:T#POV:U8#None,A#AVG_Daily_Sales:T#POVPrior12:S#Actual:U8#None),100)")