Set variable based on another field

[hopkinsc]

Hi All,

I have 2 fields, Period and QTR, the table looks like the following..

Period	QTR
1	1
2	1
3	1
4	2
5	2
6	2
7	2
8	3
9	3
10	3
11	4
12	4
13	4

What i want to do is to set a variable vCurrentQTR to use the QTR linked to the another variable vCurrentPeriod.

So vCurrentPeriod is 12, so i would want the vCurrentQTR variable to be set at 4.

Can anyone help please?

[sunny_talwar]

May be like this

Only({<Period = {'$(vCurrentQTR)'}>}QTR)

[hopkinsc]

Hi Sunny,

That doesn't seem to be correct,

What i need is to use an action to set the vCurrentQTR to the current QTR based on the vCurrentPeriod variable.

So in the attached the vCurrentPeriod = 12.

in the table, P12 = QTR 4.

So i want the vCurrentQTR variable to show 4

does that make sense? !

[sunny_talwar · Accepted solution]

Use this

=Only({<Period = {'$(vCurrentPeriod)'}>}Qtr)

[hopkinsc]

Damn, i tried that but i copied and pasted your first reply and changed the variable but the field name was uppercase and my real data is lowercase!

Thanks!

i don't suppose you have any ideas about my post yesterday?

[sunny_talwar]

Not yet... I have not got a chance to look at it ... too complicated to solve quickly

[hopkinsc]

OK , sorry its so complicated!

[sunny_talwar]

You don't have to sorry... it is me who is sort of lazy...

[hopkinsc]

haha! well i would appreciate the help when you have the time.

Many thanks!