Compare two Columns (variables)

building reports desktopintelligence
1

Hi everyone and thanks in advance,

I have a chart with itineraries info like this:
Origin Destination
A C
A B
A D
A D
B C
B C
C D
C D
C D

I dont have the chance to write the SQL query and I need to do this at the report level.
I need to count, for each origin, how many items have already got of at ecah origin resulting:

Origin Destination Result
A C 0
A B 0
A D 0
A D 0
B C 1
B C 1
C D 4
C D 4
C D 4

I want to do something like =count( where <=)

I need it to recognice the value of each individual origin cell value and compare it with all the posibilities in Destination value, but I think this is not possible in BO.

Thanks
[/list]

GonM (BOB member since 2017-01-27)

2

I’m not sure how this ties in with your expected result. The logic doesn’t compare to the results in any obvious way to me.

3

Can you do something using a concatenation of Origin - Destination if the comparison between the two matches your logic and then counting the concatenated values against each origin?

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

4

Hi,

I need to use the value off a dimension row/column as an input for a Function.

GonM (BOB member since 2017-01-27)