5 Replies Latest reply: Feb 16, 2016 9:26 PM by jagan mohan rao appala

# cumulative investment to start date selected period

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?

• ###### Re: cumulative investment to start date selected period

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

• ###### Re: cumulative investment to start date selected period

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 <?

• ###### Re: cumulative investment to start date selected period

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

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

• ###### Re: cumulative investment to start date selected period

sry  remove close in abve second exp

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

• ###### Re: cumulative investment to start date selected period

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.