Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created a block and there are positive and negative numbers. When this happens my block chart becomes like this..Image shown below
Numbers image for your reference:
If i use fabs only positive values are coming but i need to display negative values also.
Expression i have written is
=(num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00'))
Can you please help me how to get the negative numbers also.
Thanks,
Bharat
hi
use the below expression
Dual (num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00'),fabs(sum(if(isnull([Clrng doc]), [LC2 Amount]))))
Hi,
Block chart is not allow the Negative '-' values.
=fabs(num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00')))
you can try this one.
you will get the positive & negative values. but here it will not show the '-' negative symbal.
create two expression in block chart, first with fabs & second without fabs
1) fabs(num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00'))
2) num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00')
kush,
I tried your logic but I am not getting the values.
can you share the example.
As this works for pie chart, I thought it should work for Block too, but it's not working. Need to look for another solution
thanks for your reply mani.. I have tried this expression but in Block chart even the negative numbers are not displaying even without symbol...Can you please tell me how can i display those negative numbers also..
It's good that you got the solution but not exactly.
Here is how you will get the negative number on block chart.
Thanks Kush.. Can you please send the test file... so that i can go through it and also please let me know what expressions i need to write..
hi
use the below expression
Dual (num(sum(if(isnull([Clrng doc]), [LC2 Amount])),' #,##0.00'),fabs(sum(if(isnull([Clrng doc]), [LC2 Amount]))))
thanks Kush...