Good morning - could you use an example to explain the issue - I looked at your book and the parameter and the T/F filter seem to be working as I would expect
Hello Jim and Norbert, thanks for your quick reply!
Norbert, the example which you showed is for 'Top Running Total % (R.T)'=70%, and every records with Running Total %<=70% are present that is fine but my issue is when we select filter at 100%. Because of -ve sale value R.T exceeds 100% but the record with exact 100% R.T should come and filter should return true for it. But this filter gives false.
That record lies at last having R.T.=100% and have highlighted it. (Please refer sheet-1 in the file)
And even more shocking result i got on sheet-2 in which i have excluded all -ve sales , 0 and last two +ve sales records and then I get expected answer i.e. true for record with R.T.=100%.
In both sheet, R.T = 100% exactly but then why filter gives different result?
I have attached .twbx file, please check this, I respect your advice!
Not sure if I understand your challenge?
the results comes from the bottom end of your data where the sales are negative - so the last increment returns the running total % to 100
If that is a data point you want to include (sorry but I don't think you do) you could use a conditional statement around last()=0 to always include the point when the sales
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.