Division in bar chart

[bharatkishore]

Hi All,

I have a bar chart and written the following expression :

=Num(SUM({<MonthYear ={'>=$(=MonthStart(vCurrYear_SelectedMnth, 1-NUM(Month(vCurrYear_SelectedMnth))))<=$(=vCurrYear_SelectedMnth)'} >}[Strategic consumption]),'###0.0')/month(monthyear)

In bars i have data from Jan to July and this division value is only showing for one month. Now how can i show for all the months.

Can you please tell me is there anything i have to change the expression.

Thanks,

Bharat

[PrashantSangle]

can you provide sample file or provide screen shot of what you tried and what you are getting?

Regards,

[bharatkishore]

Hi Prashanth,

Pls find the attached qvw and you can see there only for july i can see exp1 data but i want to see for all the months..

[PrashantSangle]

change month(MonthYear) to num(month(MonthYear))

sum({<MonthYear=>} InsallBase) to sum(Total InsallBase)

Regards,

[bharatkishore]

Hi Prashant,

I have given the following expression:

=Num(SUM ({<MonthYear={'>=$(=MonthStart(vCurrYear_SelectedMnth1, 1-NUM(Month(vCurrYear_SelectedMnth1))))<=$(=vCurrYear_SelectedMnth1)'}

>}InstallBase),'###0.0')/num(month(MonthYear))

but still it is not working.. It is showing for one month.

[PrashantSangle]

This is because you are selecting monthyear

that's why you are getting it for one.

Regards,