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.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
