
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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??


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
