Hi Team,
I have a module in which the Timescale is Days. Now I need to get the Day from the date. E.g. for a time period 26 Jul 2015, I want to get 26 as my day. Could you please guide me on how to do that.
Please use the DAY() function.
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/DAY.html
Create a line item - number formatted and use the formula DAY(START()) in your moudule with timescale Day.
Thanks
Arun
An alternative approach is to use a combination of ITEM and DAY.
=Day(ITEM(Time))
This formula will query the current time period and then return the day value formatted as a NUMBER.
No, the DAY function can only accept date as input argument. So it does not accept the time list members.
It could be something like this..DAY(START(ITEM(Time))), I prefer DAY(START())
@ArunManickam
Yes, you are correct.
ITEM will return a time period format NOT a date format which would not be compatible with DAY().
In that case I would also recommend your solution -
DAY(START())
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.…
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
