Set Analysis

[rathnam_qv]

Hi all,

  i have the following Expression by using this i am getting current month data, but i need to get all months data.

=sum({<[Reporting Month ID]={'$(=max([Reporting Month ID]))'},Scenario={'Actual'}>}Balance

)/1000000

can any one help me...

Thanks in advance

smiley

[Gysbert_Wassenaar]

Try =sum({<[Reporting Month ID]=,Scenario={'Actual'}>}Balance)/1000000. This will disregard any selections in Reporting Month ID so the sum is calculated over all months

[nirav_bhimani]

Hi,

Remove the Reporting month condition,

=sum({<Scenario={'Actual'}>}Balance)/1000000

Regards,

Nirav Bhimani