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.
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.
