0

Problem with unique() function

Hi all,

 

I'm having trouble making the unique() function work.

 

I'm simply writing unique('Project Codes'.Currency) in my formula field. If the values selected are all the same (e.g. CHF, CHF, CHF) the formula works as intended and returns CHF. But if any of the fields are different (e.g. CHF, CHF, USD), then the formula returns as blank.

 

The field in question is a single choice field.

 

What am I doing wrong? Thanks in advance for your help.

Best regards,
Giovanni

3 replies

null
    • Giovanni_Zagarella
    • 3 yrs ago
    • Reported - view

    Bumping the post in case anyone has advices to offer.

     

    Thanks,
    Giovanni

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    If there is a choice field involved, you must use text(ChoiceField) to get the text values.

    I guess in your case you can use unique(text('Project Codes'.Currency))

    Let us know if it works or if you need any further assistance.

    Steven

    • Giovanni_Zagarella
    • 3 yrs ago
    • Reported - view

    Hi Steven,

     

    Many thanks for your input. I spoke in parallel with support, they highlighted the same thing you did and suggested a slightly different formula: unique('Project Codes'.text(Currency))

     

    This one worked for me!

     

    Best,
    Giovanni

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 265Views