Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to dynamiclly change the number format on a graph. Some of my lines of data are % and others are just numbers, so when the user filters I want the graph to change to what they have filterd on. I've got everything working except the number formats.
I was able to do this fine on a pivot but unfortuantly the same logic does not seem to work on the graph. Heres what I used for the pivot:
=
IF(NumberFormat='%',NUM(SUM( {$<Type={'MonthTarget'}>} Data),'0.00%'),IF(NumberFormat='0.00',NUM(SUM( {$<Type={'MonthTarget'}>} Data),'0.00'),SUM( {$<Type={'MonthTarget'}>} Data
)))
Any help would be greatly appreciated.
Cheers
Simon
What kind of number format settings your using for the graph?
Check the number format settings in the chart properties--> Number tab.
This should be expression default for your case.
can you uload a sample file ?
The number format is set to Expression Default.
When I do table preview, the data is showing up as a percentage but it does not display the graph as such or my my pivot.
Cheers
The number format is set to Expression Default.
When I do table preview, the data is showing up as a percentage but it does not display the graph as such or my my pivot.
Cheers
Can you upload the file?
Hi,
I've added my file.
If you change the category, the graphs change to reflect the data, but it does not change the number format.
Cheers
Number Format is null for all the months because two different number formats exists in each month.
Hi.
In your example the problem is not with number format.
There is no values to show when '%' is selected.
Add a Table Box with all fields and you'll see there are only MeasureID=3.