Hello,
I have a list with exports date and hours and minutes. I need a formula that will allow me to show on the UX, the latest date with hours and minutes. Is there such a formula?
Thanks
@ilincach: if I understand correctly, you have a list with multiple elements and in a module you have per every element saved like below?
the idea is to have the format date like "YYYY-MM-DD HH24:MM" in order that you apply an order, all the rows will be correctly ordered (even if the format is TEXT).
The Line-item has the summary setup "Firstnonblank":
and in a system module take the total value that can published in the card.
As you notice the value in SYS00 is not correct: the correct value should be "2024-05-01 14:20", so what it is needed is to order the list descending on the line-item "Date Time Export" in order that the first element to be the latest Export DateTime.
So, after you populate the list and the "DateTime Export" you need to launch the Order List Action in order to put as first element the latest DateTime Export (max).
After launching the Order Action the totals will show correct result:
If you do not want to use the Order List, you could transform the TEXT Date in number like "YYYYMMDDHHMI" and put summary as MAX and transform the MAx number back in text in order to publish it.
Hope it helps,
Alex
@ilincach, you can keep dates, hours, and minutes in text format and use the "&" operator to concatenate multiple text line items so that you can show them in whatever format you want them to be!
Thanks @Dikshant but how can i show the latest ? (for example in UX, in a card, to show the date and time of the latest extract)?
@ilincach - You can load it via integration. Which integration tool are you using?
Hi @Dikshant , the dates loads into a module and then, I need to show in the UX the latest date. So i would have thought i would need a formula to have this information shown properly
thanks a lot @alexpavel it work very good!!!! Much appreciated!
@alexpavel , this action need to be run averytime by someone or in the UX, the card will show the latest export by default with what stated abouve by you?
@ilincach The order action should be in the same process that populates the list and after the DateTime line-item is updated. This will avoid the need to be manually triggered.
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
Hi Community, I’m working with a hierarchical list structure in Anaplan: L1 Region (e.g., Asia, Europe) L2 Country (e.g., India, Pakistan) L3 Local Input (e.g., Mumbai, Lahore, Islamabad) Users are given selective access only at the L3 level (specific cities like Mumbai, Lahore, etc.) so they can input data at those…
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…