Hi all,
I have an almost finished workflow but need a column that shows the previous period.
So for example if today's the 7th of april the column should say "P06" (october is P01).
Does anyone know how to do that?
Thanks a lot!
Solved! Go to Solution.
Hi @Lu26
Does a correspondance table Like:
Month | Previous periode |
OCT | P12 |
NOV | P01 |
DEC | P02 |
... | |
APRIL | P06 |
Where you will joint by 'MonthofDate" to bring the previous periode work in your case?
Don't hesitat to share an exepmle and we can work in it together.
Thanks
Amr
Hi @AMansour,
this is the basic principle:
Month | Period |
OCT | P01 |
NOV | P02 |
DEC | P03 |
JAN | P04 |
FEB | P05 |
MAR | P06 |
APR | P07 |
MAY | P08 |
JUN | P09 |
JUL | P10 |
AUG | P11 |
SEP | P12 |
And I want to create a column that gives me the previous period based on the current date. So if we're in april, I want him to write down P06 for march (reason for that is that my data is also based on the previous month).
Do you understand what I mean?
Thanks!
Hi @Lu26 ,
I think it could be done using a formula - see attached workflow. What do you think?
Best,
Roland
Hi @RolandSchubert,
it worked perfectly fine for the "6" but unfortunately I also need the "P" in front of it (P01, P02,...P12).
Is it possible to include that?
Thanks a lot!
Thanks for your help @RolandSchubert and @AMansour !