Weird issue on legend in bar chart

[#1]

Hi,

When I put the cursor on the bar in my bar chart, it shows the value as 11.5 but on the values on data point its displaying as 0.0115.

The value is being calculated from this expression: $(vLogFn(sum([New Issuance])))

where vLogFn : pick(floor(log10(fabs($1))/3)+1, num($1, '#,##0.'), num($1/1000, '###K'),num($1/1000000, '###M'),num($1/1000000000, '###B'))

Any help, much appreciated?

Regards,

Sachin

[Anonymous]

I often find it easier to diagnose things like this by temporarily changing the Chart to a Straight Table.  Then I can really see what is happening and also add diagnostic expressions.

[#3]

Thanks Bill I don't know what was the issue. But I used a dual function:

dual($(vLogFn(sum([New Issuance]))),sum([New Issuance]))

And it worked.

[swuehl]

Isn't that because your y-axis is set to show values in Thousands (see the  'k' at the upper left)?

So the height of the bar would be 0.0115 (in k), the value is 11.5.

[#5]

No, I don't think that's the issue Stefan.

I used a dual function:

dual($(vLogFn(sum([New Issuance]))),sum([New Issuance]))

And it worked.

[#6]

Bill,

Any idea why forecast values are being shown in exponential format?

[#7]

Hi Stefan,

Any idea why forecast values are being shown in exponential format.

[swuehl]

Would you be able to share a sample QVW (could contain mock up data)?