Skip to Content
1

dashboard if formula can not work

Oct 31, 2017 at 06:27 AM

152

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Amit Anant Kulkarni Jan 24 at 04:36 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 03, 2017 at 07:17 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 17, 2017 at 09:02 AM
0

Hi Zheng,

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

Regards

Stefanie

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 23 at 02:08 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 26 at 01:30 PM
0

Thanks @amitanant.kulkarni now it is working :)

Share
10 |10000 characters needed characters left characters exceeded