Hi I'm trying to get the last quarter of the FY formula.
I have Q1FY22, Q2FY22, Q3FY22, Q4FY22. I need a boolean which checks the last quarter of the FY ie., Q4FY22. Please help.
@tampara.dora
See if this helps:
Formulas:
Another way would be by going by quarter count and checking where modulo 4 equals zero. Please find the screenshots attached.
Best regards,
Pyry
Similarly... do a check on the Year against the next year. So many ways to do this!
@pyrypeura
Good idea and a good way of accomplishing this. One caveat, try not to use the cumulate() function as it is single-threaded and could have poor performance. Instead, you can use either:
Rob
@andrewtye
Well done!
Thank You!! That helped.
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
