How to set the expression to get correct values

[#1]

Hi,

I have to use below expression to get MAX(TransDate) in straight table

Max({<TransTypeDomain={"Receipt"},Transtype={"DD","SO"},AccountTypeID={"19865"}>}TransDate)

when ActualAccountID=AccountID

Could anyone help me how to change the above expression to get correct values. Here ActualAccountID is column in Table1 and AccountID is column in Table2.

Please help me.

Thanks.

[salto]

Hello,

The syntax is correct - How are Table1 and Table2 linked? Could you Join them?

[#3]

Yes there is a join between Table1 and Table2. when I am using the abiove expression I am getting incorrect Values.

Please help me how to set this.

[#4]

Amelia,

I would add in the set Analysis the boolean expression. To do that:

AnotherFieldOfTable1 = {"=(ActualAccountID=AccountID)"}

Fabrice

[#5]

Thanks and can you explain how to use this as I couldn't able to get what AnotherFieldOFTable1?

[jagan]

Hi,

Try like this

=Max({<TransTypeDomain={"Receipt"},Transtype={"DD","SO"},AccountTypeID={"19865"}, ActualAccountID = {"=(ActualAccountID=AccountID)"}>}TransDate)

Regards,

Jagan.

[#7]

Thanks and I used the same still it is showing incorrect dates. Please help how to sort this completely.

[#8]

I think you have several fields in the Table1 where ActualAccountID is.

in fact, when you have a boolean expression in the set analysis, I stated that you cannot use it a second time. Therefore you have to write

A ={"=(B=C)"}

Fabrice

[#9]

Thanks and what it means exactly

[#10]

Do not understand ....

it means that you add in the set analysis one more clause : where the field B= the field C

it was not a point of your request ?

Fabrice