Element Function with dual field

[bgerchikov]

Hello,

Has anybody used Element Functions for dual fields with text values?

For example, Sum( ${<Field1=P(Field2)>}  Amount)  whereas both Field1 and Field2 are dual - doesn't work.

Instead:

Sum(${<Field1={"Value2"}>}  Amount)  - does work

Sum(${<Field1={$(='"'& concat(Field2,'","')&'"')}>}  Amount)  - does work

Thanks!

[anbu1984]

can you share sample data

[bgerchikov · Accepted solution]

Ok, I found out myself:

The problem was caused by the fact that Field2 is a column in the data island table along with the other columns and has NULL values. When I extracted Field2 in the separate table with no NULL values, Element function started working as needed.

[#4]

i'm glad to hear it..

Please mark your post as an answer and close this question.