- String or binary data would be truncated. ERROR

[Former Member]

was wondering if anyone is getting this error. i created a new function and for 1 of the values i get this error. i'm not sure if this is related to rounding issues but can anyone shed some light

[Former Member · Accepted solution]

Hi Elmer,

It would be really helpful if you can share the function which you have written.

[Former Member · Accepted solution]

*function ACTBUD1(%Account%)

(+([Account].[%Account%],[Scenario].[Actual]) - ([Account].[%Account%],[Scenario].[Budget]))

*endfunction

[Former Member · Accepted solution]

Hi Elmer,

I would request you to first change the name of the variable.

*function ACTBUD1(%MYACC%)

(+(Account.%MYACC%,Scenario.Actual) - (Account.%MYACC%,Scenario.Budget))

*endfunction

[Former Member · Accepted solution]

i'll try changing the variable but i really don't think the function is the problem. its only happening to one account for some reason. i've narrowed it down to which account but i'm not sure exactly why its happening there.

[Former Member · Accepted solution]

Hi Elmer,

When exactly are you receiving the error?

[Former Member · Accepted solution]

when i process the dimension i get this string error and saying that it can't expand my formula

[Former Member · Accepted solution]

Hi Elmer,

As you said that you are getting this error only for one account. The other accounts are fine. Are you using the same function for other accounts?

[Former Member · Accepted solution]

yes i'm using the same function for the other accounts. which makes no sense to me. i thought maybe its a rounding or casting type issue but i've also tried that as well.

[Former Member · Accepted solution]

Hi,

I would request you to write the entire formula for the member for which you are having the problme. The formula is not complex. Please try writing the entire formula for the member. And then process. Lets see, if you get the same error or not.