My getpivotdata (powerpivot) uses scientific numbers in the reference!?

Hi there

I'm using a simple getpivotdata function in Powerpivot where I am refering to a paticular week - in this example Week 12

Excel suggests the following reference:
=GETPIVOTDATA("[Measures].[bias%]";'Data til Dashboard (2)'!$B$8;"[Data].[Uge]";"[Data].[Uge].&[1.2E1]";"[Data].[Afdeling]";"[Data].[Afdeling].&[Foodservice]")

I want to change the [1.2E1] with a reference to a cell where I have keyed '12' - but that doesn't Work - It does Work if I write '1.2E1' but that messes up a lot of other references that I have...

Does anyone have any ideas as how to avoid the getpivotdata function to use Scientific numbers and use 'normal' numbers instead?

BR

Jesper

I'm having the same issues today - Did you ever receive a reply to this inquiry?

Unfortunately not... I had to live with the 1.2E1 bit and make workarounds with the other references...

Hi Ankur

Thanks for that. I would categorize that solution as a work-around as it doesn't precisely address the specific problem with the Scientific numbers...

But thanks for the input!

I ran into this issue of scientific notation today and was able able to solve it. The source of my data was a Power Query. The numbers getting converted to scientific notation in the GETPIVOTDATA formula were formatted as decimal numbers in Power Query. In my case, the numbers referred to "number of weeks" so I did not need them to have decimals. I changed the data type in the Power Query editor from "Decimal Number" to "Whole Number". After I refreshed the pivot table, the GETPIVOTDATA formula was no longer using scientific notation.

I realize each situation is different, so my general suggestion if you experience this issue is to test different formats in your source data.