what is #computation error in BO? Please explain me with scenario

[former_member587467]

Hi Team,

Could you please help me out what is #computation error and explain me with scenario and how to solve it?

Thanks

Siva

[Former Member]

Hi Siva,

For Instance, if you have a column called 'Salary' with full of numerical values, and one row is containing null value and then you are trying to find the 'Total Salary', then you may get computation error.

Eno      Salary

101       6000
102       8000
103       Null
104      15000

You can resolve this by making the null cell as numerical value 0(Zero).  For this, you can right a alerter saying that, If salary is null then 0 else salary. Now all the values from Salary column is numerical.  If you find the total for Salary column now, it will give the result as 29000.

Let me know if you still finding problem understating this.

Thanks,
Parimala.