Set analysis: field = other field

[#1]

Hi, how can i refer that field should equal field b with set analysis?

I suppose I don't have to use the concat and the getpossible values functions?

Thank you!

[#2 · Accepted solution]

I suppose this:

sum({$<OrderDate = DeliveryDate>} Sales)

Returns the sales for the current selection where OrderDate = DeliveryDate

[#3]

Hi, I also want to know how to put the Set Analysis when OrderDate >= DeliveryDate. I tried several things, but these didn't work. Do you have any idea?

Gr. Liesbeth

[#4]

did you solve your problem?

i need this too

[#5]

No I didn't ....

[#6]

Hi,

You will have to ensure that all dates in your model have the same layout, like 40775 or 10-10-2011

if you don't use a label in your table, you can view the outcome of your set analysis,

also, use a text box to view how your field looks like. compare dates with dates and nums with nums...