Hi,
I need a formula that can give me the actual Last day of the current month. As the current month is October'21, I want to get the result as 10/31/2021.
Can someone help me with the formula or guide me with a way around.
@ansn
If your module has Time as a dimension then use
END()
if it doesn't then you can write
END(Line item)
Line item has to be Time Period formatted
Misbah
The End() function can be used to obtain the end date of the current period.
Thank you all for the help.
The END() formula is serving the purpose.
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…