Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm working on a table that shows all item that we haven't shipped yet
I use the following expression
=Sum({$ <DOCUMENT_CODE={"BL"}>} PRICE/QTY_SOLD*QTY_NOT_SHIPPED)
I check all my shipping documents (BL) and compare Qty of ITEM Sold against Qty of ITEMS waiting to be shipped
It allows me to find orders that are not fulfilled yet (either in full or partially)
As you can see, we often have items with a price of 0.00 (repair under warranty, ...)
It works fine except for 1 minor issue. When sales persons add a discount, they use a specific item to do so.
This specific item keeps filling my reports as it's never removed (sold) and I can't have a clear view of my unfulfilled items
Is there a way to hide Rows containing specific value(s) ??
In my report, the elements I wish to hide have several descriptions, positions
Thank you for your help
Have nice day
Hi Fabien,
generally yes, you do - but you will have to implement the criteria for the >>rows you do not want to show << into your dimension - you can make a flag_field in the script combining all the criteria for >>rows you do not want to show<< and use that as a second dimension and build an IF_clause into that second dimension.
There is also the possibility to add formulas on the "presentation" tab, but I'm not sure whether that works for arbitrary rows ... just give it a try.
how is the specific item specified ?
Hi Fabien,
generally yes, you do - but you will have to implement the criteria for the >>rows you do not want to show << into your dimension - you can make a flag_field in the script combining all the criteria for >>rows you do not want to show<< and use that as a second dimension and build an IF_clause into that second dimension.
There is also the possibility to add formulas on the "presentation" tab, but I'm not sure whether that works for arbitrary rows ... just give it a try.
It's items from our ERP (don't know why they decided to use actual item for that purpose but I'm only the IT guy, I don't ask questions ^^)
Item N° that I'd like to remove from the table are
"Rabais final prix"
200028
200029
. (yes they use a dot as an item in our ERP.....)
The most commonly used item is "Rabais final prix" wich has always the same line position on our invoice: 8810
If I could remove this one at least, it would help a lot
I tried some "IF" conditions but it slows everything down (it's still manageable though)
Thank you for your help
Hi Friedrich,
thanks for your ideas.
I'll try to add some kind of flags and see what I can do from there.
I created a flag field with specific IF conditions for each Item I don't want to see then filtered this field and it works great.
Thank you