Clear Override value when the Override boolean is unchecked

Shashank123 · 2023-02-17T07:57:32+00:00

There was an error rendering this rich post.

Hello All,

I would like to clear the override line item based on whether the boolean value enabled or disabled. Please see screenshot attached for current & expected behavior

I have perused through the existing questions on this topic but couldnt really get the same problem statement.

Apologies if I missed it somewhere, if so would be nice if someone could direct me towards the thread

Accepted answers

All comments

ChrisAHeathcote

@Shashank123

Use an IF THEN ELSE statement driven by the boolean to direct the final outcome.

For example, IF the boolean = YES THEN override value ELSE Number source

It is not possible to clear out the override value as this is a user input.

andrewtye

@Shashank123 think about using DCA so the override number is editable / readable if ticked and not if it isn't.

Just pick the boolen line item from the drop-down in the override line item.

rob_marshall

@Shashank123

If you really want to clear the override value, you will have to use an action which really isn't a good thing. With that said, the formula would be:

not override? and Number Override value <>0

This will produce a boolean to use in the view for the action.

But the real question is do you really need to clear the override value? And if you do, can you hide the action in a nightly process so it has very little impact on the end users?

Rob

Shashank123

thanks @andrewtye for the response.

The DCA would serve my purpose in hiding the values when the Boolean is disabled. Will use this in my model.

Thanks @rob_marshall !

Yes, I would like to clear or not show ( as shown in above case ) the override value, when the boolean is disabled as this would avoid confusion among the users.

Thanks Anaplan community all together for helping me out considering it was my first posted query ;)

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…