Skip to Content
avatar image
Former Member

dashboard if formula can not work

hi expert,

i use a formula if like if(A1>0,1,9)

and use a "label text " components binding

but it show nothing when i preview,

i delete all sheets and add new, error still

but it can work when that formula modify like if(A1=0,1,9)

dashboard version 4.2 sp4

error like image

after preview´╝Ü

error1.png (90.6 kB)
error2.png (59.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 24 at 04:36 PM

    Dashboards 4.2 SP4 has many known issues .Try installing the patch 3 and check if it works.

    2493523 - Dashboards issues after upgrading to Dashboards 4.2 SP04

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2017 at 07:17 PM

    Hi Zheng,

    Please check the excel sheet dump after preview and see what is value it is showing in excel . Also try to add space after F4 and > . and check it. Let me know if your problem not resolved.

    regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2017 at 09:02 AM

    Hi Zheng,

    we have the exactly same issue. Please let me know if you found any solution.

    Regards

    Stefanie

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 23 at 02:08 PM

    Hi

    I have the same error. After upgrade Dashboards ver 4.1 SP4 to Dashboards ver 4.2 SP4

    Dashboard sees formulas, with character ">" or "<", as empty/null.

    Is there a solution to this problem?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 26 at 01:30 PM

    Thanks @amitanant.kulkarni now it is working :)

    Add comment
    10|10000 characters needed characters exceeded