BO Separating two value in the same attribut

Hello,
I really need your help Please. I am a beginner in Business object and I don’t know how to realise my request.
So, I have an attribut that can has many value depanding of another one, so me I need to separate them to use them in others request.

this is the link to an image illustrating what I try to explain, Numéro matériel id the ID

http://zupimages.net/viewer.php?id=16/31/2tb7.png

Please help
Thank you


5150747 (BOB member since 2016-08-04)

Welcome to B:bob:B!

It’s not clear from your description what you are trying to achieve. Can you describe it in more details?

And, which SAP BusinessObjects tool do you use? Is it Web Intelligence?


Marek Chladny :slovakia: (BOB member since 2003-11-27)

The attribute “Classe 30 sous classe 10” can have two value. And I don’t know how to separate them. I tried to write this formula but it doesn’t work :

=<Montant de l’opération> WHERE ( <Numéro d’Opération Financière>=Max(<Numéro d’Opération Financière>))

As refered in the picture that I added, I want to have this presentation :

18548, 75 , 28 886

and not 18548, 75
18548, 28 886
Beause I have to add more informations, and ith this presentation, I will have duplicates


5150747 (BOB member since 2016-08-04)

Try this:

Create a Boolean flag for each value you want to check.

Then create a max() function for each flag in the =<Montant de l’opération> operation and insert in the report in place of the original object. That should create a single row per =<Montant de l’opération> (depending on any subsequent additions).


Maddye :uk: (BOB member since 2009-01-09)