Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
rabbani_sk
Contributor III

Using Slider to change the Value in the Expression

Hi all ,

I need to use a slider which consists of 15 days ,

by selecting the no. of days on the slider, it should dynamically add the same number of days to the Promise date.. which i am using in the expression .

the expression i used is  as below,

=if(Bill.Qty>Order.Qty and Bill.Date>Promise Date, Count(S.Ord.No))

This is my expression in the pivot table, so i need to add a slider which consists of 15 days , (i.e Delay Days)

If i select the no. of Delay days on the Slider , that many days should be dynamicalluy added to the Promise date in the expression , is thios Possible are not??

1 Reply
whiteline
Master II

Hi.

Create a slider for a new variable instead of particular field.

Set the appropriate min and max values (1 and 15 in your case as I think).

Then modify your formula to add the variable value to the Promise Date.