Forum Discussion
Calculated column challenge :)
Goodmorning.
I need this calculated column based on my calendar table. The table has fiscal- year, quarters and months columns in place and it contains future years.
I need a true/false column showing only the current and last fiscal year based on today(), BUT current fiscal year must only show true for completed fiscal quarters. So 1/10 it should state q1 and past 4 quarters as true, 1/1 q2 and past 5 quarters as true, 1/4 q3 and past 6 quarters as true etc...
The client has fiscal year 30/6.
I need this calculated column based on my calendar table. The table has fiscal- year, quarters and months columns in place and it contains future years.
I need a true/false column showing only the current and last fiscal year based on today(), BUT current fiscal year must only show true for completed fiscal quarters. So 1/10 it should state q1 and past 4 quarters as true, 1/1 q2 and past 5 quarters as true, 1/4 q3 and past 6 quarters as true etc...
The client has fiscal year 30/6.
2 Replies
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
