Detach in charts

[#1]

Hi all

I am trying to detach a bar chart by using the expression below but it doesnt seem to work.

Num(If([Numerator Flag] = 1 And [Summarise Flag] = 0 , Avg({1}Numerator),

  If([Numerator Flag] = 1 And [Summarise Flag] = 1, Sum({1}Numerator),

    If([Numerator Flag] = 0 And [Summarise Flag] = 0, (Avg({1}Numerator)/Avg({1}Denominator)),

      If([Numerator Flag] = 0 And [Summarise Flag] = 1, (Sum({1}Numerator)/Sum({1}Denominator)))))),[Format Code])

[kaushiknsolanki]

Hi,

     What exactly is happening when you do some selection?

Regards,

Kaushik Solanki

[#3]

Upon selections the bar chart changes. I would like it to be static independent of selections.

I wasnt sure if the expression is right.

[#4]

Incorrect Syantax. 'No Data to display'