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.
Hi, I'd like to know if my issue already occurred to anyone here. I created a saved view out of a module using different hierarchical lists. In the saved view, I pivoted the dimensions and restricted the view only on a specific line item. Then, I used that saved view to import data into another module however the data…
Hi, I have the following problem to solve and I’m not sure whether it’s even possible in Anaplan. I have List A with a certain number X of elements. For selected elements from List A, based on which I create a subset, I determine the components that make up each element. There can be a maximum of 6 components. Each line…
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
