Financial Statement AX2012

Hi All,

Do need help for financial statement calculation. I get the below error where if one of divide is zero or negative value

Calculation error:((0)/(0))

example: 100 / 0 = calculation error or -100 / 0 = error or 0 / 100 = error

Any method can set in financial statement calculation to make it return 0 instead of throw error?

Thanks in advance for help

Rgard

Are you dividing two columns? for example #1/#2 ?

I don’t get any error if one of the values are zero.

Hi Morten Nielsen,

Yes, it was dividing calculation expression with #1 / #2.

Example:

Group A are with 3 type: dimension

Group A - 110100 type: dimension

210300 type: dimension

230000 type: dimension

Group B is with 2 dimension type

Group B - 330000 type: dimension

  • 330500 type: dimension

Calculation of total % of variance= Group B /Group A

example = 0 / 100

system throw calculation error for 0 / 100

Regards

Hi,

it is dividing by rows, not columns.

example: #1 /#2

Regards