For modules building, it would be helpful to have a ENDOFQUARTER formula to identify the end of quarter date of a date.
You could do 3 line items (Date, Period, End Date) line item—-Format—————————Formula. Date.———-Date. —————————-Start() ← Should already be in the model Period ——-Time Period (quarter)—- period(Date.) ← Would probably already be in the model End Date —-Date —————————-"end(period)" but I agree it would be quicker with one command
@MarionCarrie,
ENDOFQUARTER(Date) = IF MONTH(Date) <= 3 THEN DATE(YEAR(Date), 3, 31) ELSEIF MONTH(Date) <= 6 THEN DATE(YEAR(Date), 6, 30) ELSEIF MONTH(Date) <= 9 THEN DATE(YEAR(Date), 9, 30) ELSE DATE(YEAR(Date), 12, 31)
This formula checks the month of the given date and returns the end of the corresponding quarter.
THANK YOU SO MUCH !
In the FCR Journal module, the Search menu always pops up when you first enter the module. This makes no sense when it is likely that the user will want to create a new journal more often than not. Remove the pop up and make create new journal the first option / page and allow the user to select search as an option
Anaplan currently provides the ability to create versions via an Import action, and update Version settings via an Import action. Ability to use an action (of any type, Import or otherwise) to do the following: - Rename Versions - Delete Versions Business Need: As we seek to continuously improve our planning process…
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: When presenting visualizations in Anaplan, users often try to hover over lines/bars/points in the chart with their cursor to point…
