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
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