How to resolve this

[Anonymous]

I am facing a strange issue. Loading an excel file in the app. I have monthstart field in excel value-10/1/2016;  have second FieldB. I have a straight table using Monthstart as dimension and FieldB as expression. The straight table is empty. Both fields are coming in list boxes but straight table is blank unless I select a value from listbox. Anyone gone through this?

Thanks.

[Anonymous]

Hi Sunny I edited the excel feed to outline rounding off problem I am having. can you help me round off the values inside bars to Bil. For eg I want 456,495,000,000 to be shown as 456.5 Bil. I tried rounding off the field 'Value' at expn level but did not work. I have attached the qvw and updated excel sheet.

To get the values inside, I went to present tab ----> and then checked Plot Values inside segments.

As always, Many Thanks.

[Anil_Babu_Samineni]

Check this

I done this

Enclosed Attached

[sunny_talwar]

or you can use this expression:

=Round(Sum(Value), 0.1)

With Expression Default on Number's tab

[Anonymous]

when I opened your app it did not work it still did not round up the numbers. Pls see the image below.

[Anonymous]

pls see the attached qvw. It did not work.

[sunny_talwar · Accepted solution]

Check now

[Anonymous]

That worked. however the 'Bil' Y axis label went away. is there a way to use Bil symbol for Y axis?

[Anil_Babu_Samineni]

I've opened your application. It went well. Are you referring 7th/Jan and 8th/Jan Date of values. If so, That is the problem with Width and Height.

I had seen reply to Sunny T, Can we know where you want to show the Bil Name for Y-Axis

And i would recommend to change plot values from Inside to Normal and then use Only one value from One graph on each segment. In that, You will get pop-up for users as well

[sunny_talwar]

Here you go

[Anonymous]

Ha! I tried with Million and Billion Symbols but left that one out.

Thanks so much