So this is filtered on the specific key so the solution should also work when the filter is off.
I have deliveries and on these deliveries there are material. But also a Log Month.
What I want it to only count the quantity once.
Thought I already had that covered with looking at the max log month and only put the quantity there
But as appeared a delivery could also be be done double for only a few materials.
Therefore I had to go a level deeper on material.
I made a key combining delivery and material.
So in this example the key occurrs twice so the ‘CountMat’ should give 2 and not 1
When there is only 1 log month for a key it should give 1.
Tried several count option, for not this one is :
=Count([Variables].[Key]) ForAll ([Variables].[Delivery])
Ok got by that also with:
=If ([CountMat] = 1) Then “Show”
ElseIf ([LogMth] = Max([LogMth]) In ([Variables].[Delivery])) Then “Show”
Else “Hide”
But this thing keeps giving me headaches…because of course I want to hide these zeros.
In the formatting of the block it will not work. Guess because MthChk also needed to be a measure field for some reason.
But putting a filter on Mthck hides the lines with “Hide” but is screw up the total!
First of the Amount comes from a 2nd query and the other fields form 1st query.
These queries have been merged like this:
The key is not very special on both queries it is delivery+material
Then my initial Quantity is set up like this:
I found that the Field ‘Key’ is causing the problem.
As soon as I take it out of the layout amounts are screwed.
As you see the amounts for mth 8 are set to 0 and the total has a multivalue.
