mix of % and £ - bring through % state from excel

[#1]

Hi,

On the attached we need the figures in the month to reflect formatting from excel (where its loaded).

So within the table on each month there will be a mix % and £ depending on the indicator. This is reflected to a degree in that indicators with £'s are showing; however, the % signs are not showing on the relevant indicators..? Is there a way to show %'s?

The standard way would be to change document settings; however, this will apply to all indicators in that month, e,g October. As above there is a combination of £ and %'s within each month,

Please see app attached. Appreciate the assistance.

Chris

[#2]

Create a variable with which will store the format of the number like below

vFormat =  "=if(WildMatch(Indicator,'*%*','*Percentage*'),'#,##0.00%','#,##0')"

and use something

num(October,'$(vFormat)')

Thanks

Singh

[#3]

Hi Angad,

Thanks for this - where would I put this in the app?

Chris

[#4]

create the variable....

and then use a Straight Table and add calculated expressions using the above formula..

--Singh

[#5]

Hi Angad,

Created the variable like you mentioned (settings - variables > add):

Then gone into expression of straight table: 

However, still no joy...

[#6]

Your variable Name is not vFormat, it is %. You need to create your variable and test your variable, and then use it your expression.

[jonathandienst]

To the best of my knowledge it is not possible to automatically get the number format to match that in Excel on a value by value basis. QV usually uses the first value it loads to determine the data type and format for the field.