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 Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
