I create a line item called unit and format it as List (include pcs, kpcs, mpcs).
If i do nothing , default value is blank ,How to set default value of List to kpcs
Hi Leco1982,It's not possible to have change the default value in a line item. The only way to achieve this would be an import action. Provide an action on the dashboard that imports kpcs into all the blank line items.Regards,Anirudh
@Leco1982
It is not possible to set the a line item which is used to select the a value as a default but the following work around may offer an alternative.
Create a default line item formatted as the list and set this to the required item.
Create an override line item formatted as the list. This will be used to select an alternative to the default.
Create a result line item also formatted as the list. Using the following formula you can set this line item to equal the default line item if the override is blank.
= IF ISNOTBLANK(Override line item) THEN Override Line item ELSE default
Your user will see the Override and Result line items but you can choose to hide or make the default read only.
Therefore, the result will always show the default unless the user chooses an alternative from the override option.
Chris
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
