global variable?

Wed, 26 Jun 2013 06:11:52 GMT

Hello,

I have following Problem:

I need to calculate values for a selected Quarter and to compare them with earlier Quarters

e.g.

count (event)

count ( {$ <Quarter= {'$(#JQ_1)'} >} event) with JQ_1 beeing a global variable defining the Quarter before the selected

Now, in my model I have one table with the columns ID sincedate todate, which i cannot directly contact with the Quarter selection.

count( {$ <Quarter=> }

if (

sincedate<='$(=max(Date))' and todate>='$(=min(Date))',

ID))

I thougt i should be possible to extend the formula to

count( {$ <Quarter=> }

if (

sincedate<='$(=max( {$ <Quarter= {'$(#JQ_1)'} >} Date))'

and todate>=''$(=max( {$ <Quarter= {'$(#JQ_1)'} >} Date))',

ID))

but it doesn't work. Is it possible, that the nested global variable is the reason for?

Thanks for your help,

Benno

Re: global variable?

daveamz — Wed, 26 Jun 2013 07:14:04 GMT

Hello Benno,

Try to use above():

count(event) / above(count(event)

Regards,

David

Wed, 26 Jun 2013 07:24:39 GMT

I have solved my Problem. the Syntax was right, but with a little error in detail ...

Thanks David for mentioning above() , seems to be interresting for my tasks.

Greetings ,

Benno