Bar Chart - Value - "Text on Axis" displayed as doubled

[Anonymous]

Hi

I have a bar chart, with 3 expressions.  The first 2 are bars where the third, its just "Text on Axis".   The 3rd expression, the value displayed is double.  See screenshot below.  How do I fix this?

Kind regards

Nayan

[shanky1907]

Can you share your expressions?

[Anonymous]

Hi Shashank

Its a percentage variance between the first 2 expressions.  CY/PY -1.

CY =$(viExpense_Category(vYTD))

PY = =$(viExpense_Category(vPYTD))

Kind regards

Nayan

[techvarun]

I think it is something to check with your font settings

[shanky1907]

If i see for Telephone Cellphones Dimension:

CY=~1139 & PY=~1036

CY/PY=(1139/1036)-1 = 9.9%

Which is correct? So, i am not able to understand how it is double.

Can you please specify the scenario?

[shanky1907]

Ok... Sorry i misunderstood the thing. I got it now... That it is hsowing two times not Double Value .

Can you please share screenshot of your Expression and Axes tab ?

[Anonymous]

Hi Shasshank

In my Dimension i have a Group, which rotates between Employee and Type.  When I switch to Type, the values don't appear double, however when i switch to employee it doubles.  Below are screenshots of the expression and axis tabs.

Kind regards

Nayan

[Anonymous]

Hi Varun

I've change the font, but still shows double.

Kind regards

Nayan

[techvarun]

Share a sample qvw file with dummy data.

[Anonymous]

Hi Varun

Its complicated, but will see what I can do.  Thank you.

Kind regards

Nayan