Skip to Content
0
Former Member
Aug 08, 2011 at 01:42 PM

#Computational error in DeskI Formula

29 Views

Hi,

I need to create a single column which has around 20 objects. Out of those some are dimensions and others are measures.

While creating fromula I getting #computational error specially when adding adding measures (1st measure) to the formula.

For e.g D1.......D10 are dimensions and M1 ....M5 are measures then I writing formula as

=D1D2D3D4If (Isnull(D5) Then " " Else D5)D6D7+M1 -


resulting me #computational error

Any help is highly appreciated.

Thanks in Advance,

Suresh Babu Aluri.

Edited by: Suresh Babu Aluri on Aug 8, 2011 7:20 PM

Edited by: Suresh Babu Aluri on Aug 8, 2011 7:21 PM

Edited by: Suresh Babu Aluri on Aug 8, 2011 7:21 PM

Edited by: Suresh Babu Aluri on Aug 8, 2011 7:22 PM

Edited by: Suresh Babu Aluri on Aug 8, 2011 7:22 PM