where condition in a variable

[ali_hijazi]

Hello

got around 20 expressions that share the same where condition

<

  STEP_DURATION_MIN={"*"}

  ,RECORD_TYPE={'duration'}

  ,Year=

  ,Month=

  ,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

  >

is there a way that allows me to put the above in one variable and keep the expressions running?

Please advise

[jagan]

HI,

Try like this

vCommonStatement  = {<STEP_DURATION_MIN={"*"},RECORD_TYPE={'duration'},Year=,Month=, CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"} >}

=Sum($(=vCommonStatement ) MeasureName)

Hope this helps you.

Regards,

Jagan.

[ali_hijazi]

nop it didn't work

[sunilkumarqv]

Hi Ali,

you can put this in variable

set vVariable ='

<

  STEP_DURATION_MIN={"*"}

  ,RECORD_TYPE={'duration'}

  ,Year=

  ,Month=

  ,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

  >

';

and then you can use similar variable in expression sum({$(=vVariable)})

[pokassov]

Hi!

vTest

<

  STEP_DURATION_MIN={"*"}

  ,RECORD_TYPE={'duration'}

  ,Year=

  ,Month=

  ,CALENDAR_DATE={">= $(=date(vFromDate)) <=$(=date(vToDate))"}

  >

sum({$ $(vTest)} Qty)

[ali_hijazi]

didn't work

[ali_hijazi]

didn't work

[pokassov]

Does it work?

sum({$

<

   STEP_DURATION_MIN={"*"}

  ,RECORD_TYPE={'duration'}

  ,Year=

  ,Month=

  ,CALENDAR_DATE={">= $(=date(vFromDate)) <=$(=date(vToDate))"}

  >

} your_field_for_um)

[ali_hijazi]

yes of course

[jagan]

Hi,

Is this statement working

Sum({<

  STEP_DURATION_MIN={"*"}

  ,RECORD_TYPE={'duration'}

  ,Year=

  ,Month=

  ,CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

  >} SomeMeasureName

)

If this works then this should definitely works

vCommonStatement  = {<STEP_DURATION_MIN={"*"},RECORD_TYPE={'duration'},Year=,Month=, CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"} >}

=Sum($(=vCommonStatement ) MeasureName)

If possible attach the sample file.

Regards,

jagan.