bar graph showing weird 0 values

[dries_clairhout]

hello everyone,

Something weird.

My graph shows bars but the calculated value is 0,

as shown in the attached picture.

I use these formulas in this graph:

If(sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_DB) > sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_CR),
sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_DB) - sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_CR)
)

Does anyone have an idea how this came to happen?

Thanks in advance

DC

[vikasmahajan]

create sample app and attach the same to have more clarity hard to check with this.

Vikas 

[dries_clairhout]

Hello,

Is a duplicate of the app itself ok?

[Channa]

try to build table or KPI with this expression

see if it bring any value

[vikasmahajan]

yes

duplicate and attach the same

Vikas

[dries_clairhout]

Also,

please click on Bruvatex button and select Debetsaldo from the drop down menu next to the graph:

[Channa · Accepted solution]

it is number format issue

[dries_clairhout]

Indeed,

the money format gave some issues, number didn't.

Thanks

[ashok_rajm · Accepted solution]

Hi,
Actually if you export the data to excel, it has the values decimals like 0.00000000372529030. Because of which its showing the bar.. May be you can use number function to round of the values: Num(your_expression,Yourformat) or Round(your_expression).
Hope this will help.