Basic Calculation (Addition) not working right in Transform

[#1]

Hi All,

The Calculation

SECT A +SECT B/ 2 (if SECT A and SECT B not null)

SECT A + SECT B / 1 ( if SECT A is 0 and SECT B is not null)

is working fine in Table Chart, but not in Any other Charts

Below is the formula i used in expression

( if(isnull([SECT A])=0,[SECT A],0) + if(isnull([SECT B])=0,[SECT B],0) )

/
( if(isnull([SECT A]),0,1) + if(isnull([SECT B]),0,1) )

[phaneendra_kunc]

Hi Neelima,

Can you post a sample...

Regards,

Phani

[tanelry]

I think you can simplify your calculation to just this:

RangeAvg([SECT A],[SECT B])

Range functions are usually immune to null values which makes them handy.