A
A_Goss
I have the following formula in a pivot table:
=IF(ISBLANK(Qtr[-1]),IF(ISNUMBER(Qtr[-2]),(Qtr[-2]*-0.08)+Qtr[-2],
"),IF(ISBLANK(Qtr[-2]),0,Qtr[-1]))
First to the issues that I am experiencing. First, the formula wa
originally added as the one below but then updated to the formula abov
to correctly reflect what I was trying to accomplish.
=IF(ISBLANK(Qtr[-1]),IF(Qtr[-2]<>0,(Qtr[-2]*-0.08)+Qtr[-2],
"),IF(ISBLANK(Qtr[-2]),0,Qtr[-1]))
This issue is the original formula appears in the very first cell o
the pivot table and then periodically through out the column. So, yo
see the old formula in cell F6,F10,F20 but the new formula is in al
the others. Anyone have a clue to what is causing this and a possibl
solution?
The second issue is even though I have set the option for the pivo
table to leave a field blank when there is no data the formula i
treating it as a zero. I found a work around of coverting the blan
fields to something like "NR" but this would require I rework m
formula and it "ugly up" my pivot table.
Finally, in the formula above you'll notice that there is
calculation which multiplies a cell in the pivot table by -.08. Doe
anyone know away that I could have the formula in a pivot table poin
to a cell in the Excel spreadsheet? This would allow the user to ente
the value before refreshing the data and have it calculate correctly.
Thanks in advance,
And
=IF(ISBLANK(Qtr[-1]),IF(ISNUMBER(Qtr[-2]),(Qtr[-2]*-0.08)+Qtr[-2],
"),IF(ISBLANK(Qtr[-2]),0,Qtr[-1]))
First to the issues that I am experiencing. First, the formula wa
originally added as the one below but then updated to the formula abov
to correctly reflect what I was trying to accomplish.
=IF(ISBLANK(Qtr[-1]),IF(Qtr[-2]<>0,(Qtr[-2]*-0.08)+Qtr[-2],
"),IF(ISBLANK(Qtr[-2]),0,Qtr[-1]))
This issue is the original formula appears in the very first cell o
the pivot table and then periodically through out the column. So, yo
see the old formula in cell F6,F10,F20 but the new formula is in al
the others. Anyone have a clue to what is causing this and a possibl
solution?
The second issue is even though I have set the option for the pivo
table to leave a field blank when there is no data the formula i
treating it as a zero. I found a work around of coverting the blan
fields to something like "NR" but this would require I rework m
formula and it "ugly up" my pivot table.
Finally, in the formula above you'll notice that there is
calculation which multiplies a cell in the pivot table by -.08. Doe
anyone know away that I could have the formula in a pivot table poin
to a cell in the Excel spreadsheet? This would allow the user to ente
the value before refreshing the data and have it calculate correctly.
Thanks in advance,
And