Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Dimension with A, B, C, D values in it.
I am doing a Sum(Amount) in the expression of bar chart. Since 'A' has no Amount, it is not showing up in the bar chart. I want to show 'A' as a bar and have 0 against it. I removed Supress When value is null and enabled Zero on Bars in Presentation tab. I see the dimension now but with no value against it.
I even tweaked my expression as below but no use
if(Sum({$<[Dimension]={'A'}>}Amount)=0, NULL(),
Sum(Amount))
A bar of 0 would look exactly the same as no bar or a bar of null - there would be no bar as the length of it would be 0.
You could try using Alt(YourFormulaHere,0) to force a zero when the formula returns null, but there still won't be any bar...
A bar of 0 would look exactly the same as no bar or a bar of null - there would be no bar as the length of it would be 0.
You could try using Alt(YourFormulaHere,0) to force a zero when the formula returns null, but there still won't be any bar...
This is exactly what I want. Thank you so much 🙂