Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Remove the Reporting month condition,
=sum({<Scenario={'Actual'}>}Balance)/1000000
Regards,
Nirav Bhimani