Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be like this
Only({<Period = {'$(vCurrentQTR)'}>}QTR)
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? !
Use this
=Only({<Period = {'$(vCurrentPeriod)'}>}Qtr)
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?
Not yet... I have not got a chance to look at it ... too complicated to solve quickly
OK , sorry its so complicated!
You don't have to sorry... it is me who is sort of lazy...
haha! well i would appreciate the help when you have the time.
Many thanks!