Using a variable to calculate a period in an expression

[paul_ripley]

Hello

I would like to use a report in QV the present results based on the current period in our general ledger system.

I am loading the field cur_period from the general ledger system

Period:
LOAD * ;
select p.period as cur_period from acrtransgr p

I then set up a variable vCur_period with the definition  =cur_period

And then in the expression have used

=sum({$ <period = {"=$(vCur_period)"} >}Count)

to try to pick up the current period, but it doesn't seem to recognise the variable.  What am I doing wrong?

Many thanks

Paul

[Anil_Babu_Samineni]

How you defile the variable? May be this?

=sum({$ <period = {"=$(=vCur_period)"} >}Count)

[sunny_talwar · Accepted solution]

How about this?

=Sum({$<period = p(cur_period)>} Count)

[paul_ripley]

Thanks Sunny that worked.  Can I just ask you the significance of the 'p' before (cur_period)

[sunny_talwar]

p() and e() are part of indirect set analysis... look here:

P() &amp; E() and where do you use them?

[sunny_talwar]

Also here:

P() &amp; E()