Expression help.

[#1]

Sum([Annual amt])

/

if([BLD]='Own',Sum([BLDH]),Sum([BLDL]))

I am getting memory allocation full when I use the above expression in bar chart.Am I doing anything wrong here ?

Thank you.

[MK_QSL · Accepted solution]

Sum([Annual amt])

/

SUM(if([BLD]='Own',[BLDH],[BLDL]))

[m_woolf]

I would rewrite the denominator as:

SUM(if([BLD]='Own',[BLDH],[BLDL]))

Can this value ever be zero? As I'm sure you know, dividing by zero is a no-no.

[#4]

Thank you Manish.