Month & Date calculation

[#1]

Hi All,

I have to develop below dashboard based on the below conditions.

I have to get total by month. 

1. If there is no selection of Year, Month, Day (Default to Current year, Current month total  and so on)
2. If Year only selected and that is Less than current year, show DEC month & Selected Year.

e.g. 2013 selected, totals should be DEC & 2013, Nov2013,oct 2013, sept2013.

     3. If Year only selected and that is Current year default to Current month & current year  and so on.

e.g. 2014 selected, show Sept 2014, aug 2014, july 2014, june 2014.

  4. If Year, Month selected – show as selected in boxes.

5. If Day only selected, show the current month and current year and so on.

6. If month only selected, show current year and current month and so on.

  7. if Quarter selected and no year selected, show that quarter months and current year

  8. if year and Quarter selected – show those months.

[marcus_sommer]

You could read the selections with getfieldselections(), getselectedcount() and so on and use these values for your calculations, for example:

if(getfieldselections(Year) = year(today()), THEN, ELSE)

if(rangesum(getselectedcount(Year), getselectedcount(Month), getselectedcount(Day)) < 1, THEN, ELSE)

But I think 8 different levels are too much, it will be (too) difficult for a user to find out which selection leads to which calculation.

- Marcus

[#3]

Hi Anyone,

used this before?

Thanks,

Lakshmi