Set Analysis Dimension=Dimension

[#1]

How would i convert this to a set anlysis?

if(Receipt_Store = Return_Store, min(Receipts.DATE))

[#2]

min( {$<Receipt_Store = {'Return_Store'} >} Receipts.DATE )

[jonathandienst]

Hi

Assuming that you are looking for the minimum Receipts.DATE when the Receipt_Store is the same as the Return_Store:

If type: Min(If(Receipt_Store = Return_Store, Receipts.DATE))

Set Anal: Min({<Receipt_Store=Return_Store>} Receipts.DATE)

Jonathan

[#4]

not sure why, but this returns null (-).

[jonathandienst]

To clarify

Min({<Receipt_Store=Return_Store>} Receipts.DATE)

Matches the value of field Receipt_Store with the value of field Return_Store

Min({<Receipt_Store={'Return_Store'}>} Receipts.DATE)

Matches the value of field Receipt_Store with the literal text 'Return_Store'.

Jonathan