cumulative investment to start date selected period

[#1]

In Set analysis

// cumulative investment to start date selected period

sum({$<
            AsOfDate ={<min(AsOfDate)},        // everything before the minimum date
              Class_07={'AW'}                  // only the acquisition values
           >
            } Grootboekmutaties_Bedrag)

  What would be the correct formula?

[PradeepReddy]

sum({$<AsOfDate ={"<$(=max(AsOfDate))"}, Class={'AW'}>} Grootboekmutaties_Bedrag)

[Chanty4u]

Sum({$<AsOfDate ={'$(=Min(AsOfDate ))'},Class_07={'AW'}>}[Grootboekmutaties_Bedrag])

Sum({$<AsOfDate ={'$(=Max(AsOfDate ))'},Class_07={'AW'}>}[Grootboekmutaties_Bedrag])>}[Close]) for current

[Chanty4u]

sry  remove close in abve second exp

Sum({$<AsOfDate ={'$(=Max(AsOfDate ))'},Class_07={'AW'}>}[Grootboekmutaties_Bedrag])>}

[#5]

Both scripts work

The formula only works with <= and doesn't work with <

How can I use < in set analysis?

This statement works for <=

sum({$<AsOfDate ={"<=$(=max(AsOfDate))"}, Class_07={'AW'}>} Grootboekmutaties_Bedrag)

But for <?

[jagan]

Hi,

sum({$<YearFieldName=, QuarterFieldName=, MonthFieldName=,AsOfDate ={'<=$(=Min(AsOfDate))'},       
              Class_07={'AW'}              
           >} Grootboekmutaties_Bedrag)

YearFieldName=, QuarterFieldName=, MonthFieldName= ignores selections in this fields.

Hope this helps you.

Regards,

jagan.