Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there any way to ignore the active filters on a sheet, for a table with an if statement?
For example, I have a filters made on my app that mades AllocYear = 2018. But, at one of the app sheet's, there's table that discriminates some orders and I'm using something like this expression:
= If (OrdStat = 'CONFIRM' and Today ()> LateDisp and FinUnits <OrdUnits and InternalServPfeYn = 'N' and InternalServExternalPi = 'N', ItemOrd)
I wanted to add something that would ignore the fact that I have the AllocYear = 2018 made and would make me consider all the orders for AllocYear = 2018 and 2017.
Thank You.
alter ur expression as follow:
sum( {<YearField= OrdStat = {'CONFIRM'} , LateDisp={"< $(=Today())"} ,FinUnits ={" FinUnits<OrdUnits"} ,InternalServPfeYn = {'N'} ,InternalServExternalPi ={'N'} >}ItemOrd)
stalwar1, do u confirm?
espercially this part : FinUnits ={" FinUnits<OrdUnits"}
Thanks for your reply, Omar.
This would be a good solution but with the sum function I'll have the amount of orders in that conditions ... I want to insert this expressions into a table in order to see all my orders broken down (order's code)
Are you using the above as a Measure or dimension?
As a Dimension
Any measures in the table or just all dimensions?
All dimensions!
I think to make this work... you will need to have at least one expression in your chart...
What I have is a table ... does that change anything?
It should not change anything... just add one expression or use one of the dimensions as an expression...
So, for instance....
Dimension
ItemOrd
Measure
=Only({<ItemOrd = {"=OrdStat = 'CONFIRM' and Today() > LateDisp and FinUnits < OrdUnits and InternalServPfeYn = 'N' and InternalServExternalPi = 'N' "}, AllocYear = {'2017', '2018'}>} AnotherField)