If I forgot to enter a value or made it as blank in a cell in grid, how can I show a validation or something that will prevent me from saving that particular grid without that data.
Can somebody please assist me in getting a workaround for the same.
Anaplan does have some limitations in regards to data validation. Specifically, it cannot prevent a missing value. In addition, it can't prevent many incorrect values.
This said, there are some things we can do to flag bad (or missing) data, as well as prevent that data from being shared in downstream models or applications.
First, we can use Conditional Formatting to highlight where values are either invalid or missing. In most cases, the conditional formatting rule is tied to a 2nd (often hidden) line item that contains a formula that evaulates to some specific numbers that help control the related conditional formatting colors.
Second, where data is being exported to another model (or application), we can apply filters that remove the bad data from the export, so that only validated data gets exported.
It goes without saying that we can create (what I refer to as) Audit Dashboards that allow us to quickly see our key data filtered to only show invalid (or missing) values. This way, we can fix things without having to search too long.
Cheers!
Thank you so much paul for the woraround.
XL3SetProperty to navigate
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
