nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ENDOFQUARTER formula

MarionCarrie

For modules building, it would be helpful to have a ENDOFQUARTER formula to identify the end of quarter date of a date.

Comments

Rnilsson

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

Dikshant

@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.

MarionCarrie

THANK YOU SO MUCH !

Quick Links

New ideas

Quick Collapse of expanded grid rows
Quick Collapse of expanded grid rows will help improve usability of this new feature.
Expand/collapse for hierarchies on columns and line items
The new expand/collapse functionality for hierarchies on rows is a great improvement! It would be helpful to have the same functionality when a hierarchy is pivoted to the columns. This would give users more flexibility in how they structure a view while still being able to hide or show detail. It would also be useful to…
Validating ADO transformation view rows against Anaplan lists
I have encountered a gap in ADO's filtering capabilities for transformation views that I believe many integration professionals share. When working with source data, it is common to receive files that contain codes — currency codes, cost center codes, product codes — that are not relevant to the current Anaplan setup.…