Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
V
V
VolkovDen2022-01-27 09:23:11
excel
VolkovDen, 2022-01-27 09:23:11

Calculated field MS Excel 2016, how does it calculate the data received COUNT?

Good day!

I have a pivot table, one of the fields of which receives the value of the COUNT(Quantity) function from a column with text content
61f2377856d8a658045202.jpeg
And receives them quite correctly
61f237cd549a6835510573.jpeg
But when I try to process this data (I need to calculate the percentage of this field to another) - the data disappears somewhere ...
61f23891c47d9264048134.jpeg
I tried to put in the "Formula" "=COUNT(Field_Name), but I got "1", which, in my opinion, indicates that the calculated field does not receive data from the source table, but from the results of the pivot table, otherwise why COUNT gets "1" But SUM in the same case displays "0" ... and then my pot boiled.

Why is this, and how to fix it?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
B
blabs2016-05-25 10:53:47
How to spell out numbers in excel automatically? 3Reply
A
alexander_chn2018-10-25 09:59:24
Why does the module for unloading goods in opencart not work? 0Reply
S
Shavadre2014-04-09 07:02:05
How to unload a graph from a web form in MS Excel? 1Reply
N
Nastushik2020-09-09 21:10:06
How to import tables on each new sheet of an excel book and, when re-importing, if the numbers match, add a line where the numbers match? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question