or-connection

[markus19-85]

Hi, I have the following problem.

I want to use an or-connection in my application.

If I select BMW and the colour blue, I get an amount of 10, but I would like to get the amount of all BMW and all cars with the colour blue.

Is this possible, maybe in script or as a function?

Thanks for support

[MarcoWedel · Accepted solution]

=Sum({$<Colour=>+$<Car=>}Amount)

[stigchel]

You can use set analysis for that, for the above example

=sum({<Colour,Car=Car>+<Car,Colour=Colour>} Amount)

[markus19-85]

sorry, but this is not working

[Qrishna]

For Code, See Attached.

[stigchel]

Your reply is not very helpfull in resolving this, what is not working?? Not at all, other value then expected? What value do you expect?

See attached, for me working, example

[MarcoWedel]

like this?

hope this helps

regards

Marco

[markus19-85]

Yes, that's what i am looking for, thank you.

But does it also works with another field? for example, Sales_Person?

[markus19-85]

any other solution, for more than two fields?