Last answered:

02 Dec 2021

Posted on:

20 Nov 2021


Resolved: Hi can anybody would help me with problem

I am getting 0 in the 'cost of good sold'  row
formula which I am using is

 =IFERROR(GETPIVOTDATA("Sum of "&$B23,pivot_financials!$A$3,"Month",D$12,"Year",D$13),0)


1 answers ( 1 marked as helpful)
Posted on:

02 Dec 2021


Hi jee,
thanks for reaching out! You're missing an 's' in the Cost of Goods Sold column name. Is it possible that this is the reason for the error? From what I can see the rest of the calculations in the upper rows seem in order.
Let me know if there are any further issues!

365 Eli

Submit an answer