Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sum([Annual amt])
/
SUM(if([BLD]='Own',[BLDH],[BLDL]))
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.
Thank you Manish.