HELP! - Set Analysis

[#1]

Hi,

My financial year starts from April till March.

I would like to calculate Feb YTD 2011 which means total amount from April until Feb 2011

Issue: WHen I select MonthName - Feb, my formula only show the amount for Feb. It should sum up from April until Feb.

The weird thing is when I select MonthID, it works perfectly

HOw to make it works by selecting MonthName?

I have attached the sample

[#2]

solved already. thanks

[#3 · Accepted solution]

Please, check the attachement.

Kiran.

[#4]

Just wonder why we need to put blank parameter since MonthID will link to MonthName & vice versa?

[#5]

First of all did this work for you?

If you are just running without MonthName, $ forces set on available data set. Since the computation involves outside the selection block we need to consider the field on which selection is made.

Kiran.

[#6]

yes, it works!

Thanks!