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 !
Description Currently, scroll bars in Anaplan UX grids and cards only appear when content exceeds the visible area and when you hover over a card and the scroll bars appear. While this behavior is standard, it can create usability challenges for end users, especially when: Users are unsure if additional data exists beyond…
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: I have a small improvement request for assigning security rights to different security groups in AnaplanXL - it makes sense having…
I would like to pre setup input Booleans by default to true in the blueprint view //GP
