Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
sum({$<AsOfDate ={"<$(=max(AsOfDate))"}, Class={'AW'}>} Grootboekmutaties_Bedrag)
Sum({$<AsOfDate ={'$(=Min(AsOfDate ))'},Class_07={'AW'}>}[Grootboekmutaties_Bedrag])
Sum({$<AsOfDate ={'$(=Max(AsOfDate ))'},Class_07={'AW'}>}[Grootboekmutaties_Bedrag])>}[Close]) for current
sry remove close in abve second exp
Sum({$<AsOfDate ={'$(=Max(AsOfDate ))'},Class_07={'AW'}>}[Grootboekmutaties_Bedrag])>}
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 <?
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.