List box multiple selection and variable not working

[milindnikumbh]

Dear Experts ,

Greetings !

Attached is the my document. Its working fine when I select the single Fiscal Year . But when I select multiple fiscal years, my last graph is not displaying the data. All variables are populating data correctly in text item. But not able to use in expression.

You suggestions / help is highly appreciated.

Thanks.

Regards,

Milind.

[YoussefBelloum]

Hi,

it is not populating correctly because of the SubField function Subfield(Fyr,', ',1).

t takes only the first fiscal year if yo select 2

why do you use this condition actually ?

[mdmukramali]

Hi Milind,

i look at your expression which you are using in the chart.

i didn't found any field or variable with the name CLY .

from where you are using CLY ?

[woshua5550]

Hi ,it's a group name

[isorinrusu]

Try this in your expression:

=Round ( if(getcurrentfield(CLY)='PRODT', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTION TONS]) ,

      if(getcurrentfield(CLY)='PRODQ', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTIN(A+B)]) ,

           if(getcurrentfield(CLY)='SCRAPT', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[Scrap Tonnage]) ,

               if(getcurrentfield(CLY)='SCRAPQ', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[Scrap Qty]) ,

                       if(getcurrentfield(CLY)='SCRAPP', ( sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[Scrap Tonnage]) / sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTION TONS]) ) * 100

               )

               )

               )

               )

               )

        )

[woshua5550]

if user selected '2013-2014' & '2014-2015' , what data do you want to show ? '2013-2015' ?

[milindnikumbh]

Then it will show all quarters of 2013-2014 in one chart and I will deploy same chart for 2014-2015 .

[milindnikumbh]

Its not working.

[milindnikumbh]

I need to show bar chart per year. ( all quarters in one graph ).

[milindnikumbh]

this is giving error :

=Round ( if(getcurrentfield(CLY)='PRODT', sum({<FiscalYear={"$(=Subfield(Fyr,', ',1))"}>}[PRODUCTION TONS]) ))