Current Slections Straight table showing Duplicate values

[psankepalli]

Hello Experts,

I am using straight table instead of current selections option. My intention is I want to show list of current selections into straight table. somehow few of my dimensions showing twice into the straight table and few other once. I am really not sure what is causing problem.

Here is my Expression

*************************************************

= if(index(vCurrentSelections,only({1}$Field) & ':')>0,

  textbetween(concat(TOTAL DISTINCT (OldName & ':'&  NewName),'|',OldName ) & '|',only({1}$Field) & ':','|')

  )

*************************************************

Here

vCurrentSelections is list of current slections from that sheet.

Old name and new name coming from INLINE table.

$Field= Dimension

Let me know if anyone need more info , so that I can provide.

Thanks

KR

[Oleg_Troyansky]

It would be easier to troubleshoot if you could post a sample document.

[#3]

Seems your Only conditions are causing issue. but as Oleg said a sample Doc will always help to understand situation better.

[psankepalli]

I found the solution, its problem with my logic. next time I will share the sample document. thank you very much for your response.

Expression:

1^st Expression: NewName2

= if(index(vCurrentSelectionsI,'@' & only({1}$Field) & ':')>0,
textbetween(concat(TOTAL DISTINCT (OldName & ':'&  NewName),'|',OldName ) & '|',only({1}$Field) & ':','|')
)

This logic has solved my problem.