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())
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
