Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Angad,
Thanks for this - where would I put this in the app?
Chris
create the variable....
and then use a Straight Table and add calculated expressions using the above formula..
--Singh
Hi Angad,
Created the variable like you mentioned (settings - variables > add):
Then gone into expression of straight table:
However, still no joy...
Your variable Name is not vFormat, it is %. You need to create your variable and test your variable, and then use it your expression.
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.