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: The new conditional formatting functionality on KPI cards is a welcome enhancement to the Anaplan UX! However, hovering over a conditionally formatted KPI value or status icon displays the underlying conditional formatting configuration, including minimum, midpoint, and maximum threshold values. For dashboard…
I asked Claude to add line items and a formula to a planning model in Anaplan, and it did the job in a few minutes from plain sentences. No special add-on, no clicking through menus myself. That is exciting, and it raises the question every team should ask first: what happens to our data? The short answer is that it…
ADO can handle inbound PGP encypted files (as per https://help.anaplan.com/pgp-encryption-in-pipelines-8f662578-1a51-467b-9817-3083f170511c). However, outbound there seems to not be a solution. Please provide a way to create an encryption key using PGP for files to be provided into a SFTP connection.