Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Wanted to show an additional item in a bar popup using an expression without the "Bar" ticked but with a set "Text as Pop-up".
Value appeared in popup without label (dispite providing a label value with the expression) but I found a discussion item that told to add the Label into the expression
e.g. ='Label = ' & sum(value)
With this I lost the number format set in the Numbers section for the expression (which I can understand as I do not provide a number as value).
Tried to format the number myself using
='Label = ' & num(sum(value),'#''##0') // note: 2 single quotes in single quoted #''##0
Now I get the number formatted as : 54'3'210 which looks to me like unexpected??
In addition, had quite a few fights with bar charting and the limited options with providing a COOL Popup window.
Using the first expression for dimension limit only I lost formatting on Y-Axis. Getting that in place again by ticking "Value on Data Points" I ended up with a mismatch in bar color and legend color by not using first expression as a bar value (solved paritially by assigning background color to the expressions, partially because I have now static colors on expressions and dimension groups won't work as before).
Thanks for more help, Juerg
You want the single quote as thousand separator?
Try
num(sum(value),'#'&chr(39)&'##0','.',chr(39))
What happens when you try:
Num(sum(Value), '#.##0')
Or if it is Money try:
Money(sum(Value))
You want the single quote as thousand separator?
Try
num(sum(value),'#'&chr(39)&'##0','.',chr(39))
Hi
I am on a swiss german machine and my Thousend Symbol is the single quote..
using '#.##0' results in 543210.##0
Juerg