0

Color of formula field

I want to be  able to change the colour of a formula field while displaying the result of the formula based on conditions. Example. Red if result is less than 0 and green if result is greater than 0.  I tried the styled and the color formula and could not make it work. Is this feasible?

7 replies

null
    • Leonid_Semik
    • 6 yrs ago
    • Reported - view

    Hi, 

    ---

    let AA:=(your conditions);

    styled("", if AA< 0 then "red" else "green" end)

    ---

    regards

    Leo

    • Alain_Bureau
    • 6 yrs ago
    • Reported - view

    Excellent--Thank You

    • Alain_Bureau
    • 6 yrs ago
    • Reported - view

    Leo, it does not work.  It truns green alright, but does not display the value resulting from the formula.

    • Leonid_Semik
    • 6 yrs ago
    • Reported - view

    if you need display from value, then:

    ---

    let AA:=(your conditions);

    styled(text(AA), if AA < 0 then "red" else "green" end)

    ---

    Leo

    • Alain_Bureau
    • 6 yrs ago
    • Reported - view

    It works. Great. Thank you very much!

    • Producer, Manager
    • Jan_Inge_Iversen
    • 5 yrs ago
    • Reported - view

    Is it also possible to change the color in for example appointment to show diffrent colors in calendar based on diffrent choice you choose in another field?

    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi,

    Yes, that should be possible
    I have invited you in a separate e-mail to our "Webinar team EN 2019". Please accept the invitation to get access to the team and the approx. 150 demo databases. 

    There you will find a database "99_appointment colour per doctor" where kind of that scenarion is shown.

    Kind regards, Jörg

Login to reply

Content aside

  • 5 yrs agoLast active
  • 7Replies
  • 4667Views