Driver Line Item for Action Button

rachmitadhila

I have condition in card where user can input negative value.

But when the value is negative, the button will disable to click.

I have data Product as Context Selector, Time Period Month in Column, and Line Item to input Order Quantity Review in Row.

User will input number of order quantity review, but when the value is negative, the button will disable to click.

I create line item for driver in the same module with formula below:

IF    'Order Quantity (Review Input) >= 0 THEN TRUE ELSE FALSE

But when I applied this driver line item to action configuration, it only worked for Product A in Jan-24. Meanwhile, I want this driver line item to be worked on every Product that will be selected and for every month not only Jan-24.

Does anyone know how can I implement this?

Thank You..

nvilkko

Hi @rachmitadhila,

The action driver is context specific, so with your current formula it checks only the input from Product A (when you have selected it) and only Jan 24.

1. If you want to the logic to be product specific, then the formula would be something like this:

'Order Quantity (Review Input)[SELECT: TIME.ALL PERIODS] >= 0

Then it will check all monthly inputs for the selected product.

2. If you want the logic to check all products and periods then you also need to select the total level of the products.

With the first solution, remove time dimension from the action driver line item and with the second remove both product and time dimension.

Hope this helps,

Niko

rachmitadhila

Hi @nvilkko

Thank for your answer.

I tried implement the first solution but it seems like it will SUM the 'Order Quantity (Review Input) for All Periods. If the total is negative value, then the button will disabled.

But, what I'm looking for is, I want to check it for every month. If user input negative value even in one month only, and accumulative value for All Periods is still positive value, I want the button to be disable.

Do you know how to achieve this result?

nvilkko

Hi @rachmitadhila,

Sorry, I didn't get a notification for this. That is a very good point.

You can achieve it by creating first a count line item where the formula would be something like this:

if 'Order Quantity (Review Input) < 0 then 1 else 0

And then the Action Driver line item:

Count[SELECT: TIME.ALL PERIODS] = 0

seymatas1

I accomplished something similar by using "All" summary method and selecting the total on the UX page. It can be useful in your case.
Screenshot 1: Blueprint view of the module

Screenshot 2: Grid view of the module:

Screenshot 3: User View of the UX page

Screenshot 4: Edit View of the UX Page
Since "Total Accounts" is selected at the page selector, action button is disabled.

Screenshot 5:

Since a nonblank account is selected at the page selector, action button is enabled.

Screenshot 6:

Since a blank account is selected at the page selector, action button is disabled.

I included the 4th, 5th and 6th screenshots for demonstration purposes. Your setup will be similar to the 3rd screenshot.
Let me know if this is helpful.