Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an expression like ,,7 in which i need result in another expression like 7
IF expression has something like ,Top3,1, Result should be 3
All the values in the expression are separated by commas, I need first sorted value among those.
,,7 this value is coming from an expression which is combination of fields separated by comma.
Help me how to achieve this logic .
Thanks,
Venkata
Can you provide some more information.
It is very difficult to understand from you question.
It's looks confusing...
I have an expression
if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()])
which is giving results such as ,,,7
Top 3,,2
I Need another expression in which result should be 7
3
Don't understand at all.
Can you share sample file or apps?
@
Left(KeepChar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'0123456789'),1)
Thank you Manish .This is helpful if suppose there is something like Tier2,,,
Result should be named as 5 .
Only for this scenerio
IF(Left(KeepChar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'Tier2'),5)='Tier2',5,Left(KeepChar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'0123456789'),1))
Hi Manish,
If there is TOP10, it is displaying 1 instead of 10 .Any suggestion.
Can Anyone help me how can i get the first number from the expression .
I tried the expression below.
Left(KeepChar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'0123456789'),1)
But if i have numbers like TOP 10, it is displaying 1 instead of 10 .
Thanks in Advance,
Venkata