Forum Discussion
Helper ISearch with multiple criteria
Helper IHi Jihwan_Kim
Thank you for your answer. I want to see one unique value as output.
So if the output is multiple output, i only want to see one unique value. If this one is already used as output i want to see another one (if there is another one).
Like this example:
so as output i want to see one value by row. see this example:
i have crossed out the unnecessary ones
Super UserHi, Thank you for your information.
I am still a little bit confused. How to select which invoice number is used by which one?
- angelikakolacz
Hi Jihwan_Kim
If in the output a value is already used, it's not possible to see them again. in the output i don't want to see double values. Is it possible to use this like a criteria? - Jihwan_Kim
Hi,
Thank you for your information.
Sorry to bother you again, but what I meant was,
in the below picture that you shared,
why first row takes 8100000003181511? why not 810000003181814?
How do you define the difference between the first row and the second row?
- angelikakolacz
Hi Jihwan_Kim
It's only an example. it doesn't matter which one you take, if the value is unique (not already used before) it's oke.
- angelikakolacz
Hi Jihwan_Kim
what I actually want to see is how many invoices are 0 (credit + debet) on balance if;
- it's the same account number,
- period it's the same- sum of two invoices is 0.
But it is possible that in my file for a periode are 5 debet invoices and 4 credit invoices (same period). so 8 of them are right, but one is not good. In mine results i want to show that.
I must be able to show my results on row level, hence a new column with output.