someone can tell me what this code means ?

[#1]

Hi All,

I found this calculation ,

and I am trying to understand how the sum() calculate if there is '=' sign  in it .

this is the code :

sum({<DateNum={$(vCurrentDate)}, [Source Type] = [Source Type] * {"=[Source Type]=3"} $1 >} [Operational Amount])

what does it means? how is the calculation accrue ?

thanks

Moni

[swuehl]

The code between {<  and >} is called set analysis:

A Primer on Set Analysis

[maxgro]

I think without $1

sum({<DateNum={$(vCurrentDate)}, [Source Type] = [Source Type] * {"=[Source Type]=3"}  >} [Operational Amount])

[smirkinaa]

Hi. Does this expression work?

[smirkinaa]

DateNum, [Source Type] and [Operational Amount] are fields of data model, which consist from tables.

vCurrentDate is variable.

Sum([Operational Amount]) is ordinary operation of adding all values of field [Operational Amount].

{<DateNum={$(vCurrentDate)}, [Source Type] = [Source Type] * {"=[Source Type]=3"} $1 >} is expression of set analysis, which sets selections in fields "DateNum" and [Source Type] for reducing amount of values in field [Operational Amount], which will be add.

DateNum={$(vCurrentDate) sets selection in field "DateNum", which equal variable "vCurrentDate".

[Source Type] = [Source Type] * {"=[Source Type]=3"} sets selection in field [Source Type], which consist from:

1. current selection in field [Source Type];

2. value of field [Source Type], which equal 3.

But total selection will be as crossing between them. Values, which are in both parts will put in total selection.

Sorry for my english.

[swuehl]

The $1 could be part of a dollar sign expansion with parameter (see also the HELP), are you taking this code from a variable definition?

[#7]

the original value is :

=$(=Replace(Only({1<_MetricID={'-55'}>} _MetricCalc), '$1', ', $(vCurrentFilter)'))

the vCurrentFilter  parameter value is _YearPeriod={201412}

I do not understand what it does

[#8]

the original value is :

=$(=Replace(Only({1<_MetricID={'-55'}>} _MetricCalc), '$1', ', $(vCurrentFilter)'))

the vCurrentFilter  parameter value is _YearPeriod={201412}

$1' =   sum({< DateNum={"<=$(vCurrentDate)"} $1 >} [Budget Transfers])

I do not understand what it does

[swuehl · Accepted solution]

I believe it's replacing $1 with ', _YearPeriod = {201412}':

sum({<DateNum={$(vCurrentDate)}, [Source Type] = [Source Type] * {"=[Source Type]=3"} $1 >} [Operational Amount])

-->

sum({<DateNum={$(vCurrentDate)}, [Source Type] = [Source Type] * {"=[Source Type]=3"} , _YearPeriod = {201412} >} [Operational Amount])

Then it evaluates the aggregation incl. the set analysis (see my above link for more about set analysis, also the HELP and search the forum).