Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Ferdi]

I am trying to build a field that shows me

• Song Title, if the rating is 0
• Song Title (Rating), if the rating is greater 0

I use this to achieve that: IfElse(isequal([Rating], 0, 2),[Name],1,[Name] ([Rating]))

Output is correct when a rating exists, but includes a closing bracket if no rating exist. For example:

• All Our Songs), with zero star rating
• Life In Vain (4), with a 4 star rating

Is that a bug or a user error?

[marko]

User error
brackets are a part of the expression language, so, those that you want to be part of your output must be escaped, like so...

IfElse(isequal([Rating], 0, 2),[Name],1,[Name] /([Rating]/))

https://wiki.jriver.com/index.php/Expression_Language#Expression_Language_Syntax

[Ferdi]

Thanks for quick reply and help of fixing this (like, within a minute?)!

(and thanks to zybex for Zelda https://yabb.jriver.com/interact/index.php/topic,125975.0.html)

[zybex]

You're welcome