Using variables in set analysis

[arsenal1983]

Hi,

I would like to count all documents that have one parameter >=  defined in variable

I did this:

=count({$<PARAMETER = {$(#vPARAMETER)}>} DISTINCT DOC_NO)

it works if I would like to count DOC_NO where PARAMETER = vPARAMETER, but I would like to count DOC_NO where PARAMETER >= vPARAMETER.

regards,

L

[oknotsen]

How about this:

=count({$<PARAMETER = {>= $(#vPARAMETER)}>} DISTINCT DOC_NO)

[Agis-Kalogiannis]

Try Onno's suggestion with some extra quotes...

=count({$<PARAMETER={'>=$(#vPARAMETER)'}>}DISTINCT DOC_NO)

[Anonymous · Accepted solution]

Try this:

=count({$<PARAMETER = {">=$(vPARAMETER)"}>} DISTINCT DOC_NO)

[arsenal1983]

Thanks, it works.:)

How about if I would like to add two dimmesions or modify vPARAMETER

example PARAMETER  >= vPARAMETER - 360?

[Anonymous]

Probably this:

=count({$<PARAMETER = {">=$(=vPARAMETER-360)"}>} DISTINCT DOC_NO)

notice the "=" sign before vPARAMETER, it is essential here.

[arsenal1983]

Magic! and if I would like to use another varaible instead of hardcode 360?

[Anonymous]

I guess, this:

=count({$<PARAMETER = {">=$(=vPARAMETER-vPARAMETER2)"}>} DISTINCT DOC_NO)

[arsenal1983]

One more qestion, is it possible to use expresion with variable in argument of set something like:

=count({$<(PARAMETER - vPARAMETER3) = {">=$(vPARAMETER)"}>} DISTINCT DOC_NO)

[Agis-Kalogiannis]

The first part of the Set modifier is the field name.

I don't think you can do something like that.