Calculated Field, Multiply Count Column by 6.5

[thenewkidd]

All,

I'm sure this is a simple solution but for some reason the calculation is not correct.

I created a Pivot Table based on a "Pickers" table.

Everything is straight forward but when create a column for "Count of Dates" (considering only the dates the Picker worked).
I want to multiply that number by 6.5 Now of course I can do this outside of the pivot table and just take M2*6.5 and drop it down, but I would have to keep doing this every time I refreshed the data.

If I go to "Calculated Field" the "Count of DATA" is not available so it multiples the actual date value by 6.5 giving a very large number clearly not 6.5*11 or what ever value is in the M column.

Anyway.

See attached.

By the end it should be multiplying 6.5 by the "Count by DATE" column and not the date value but the actual numeric value in that column.

[q2009]

Hello! Add data to the data model. After building a summary based on the data model. Add the measure and get what you want (watch the file).