Inconsistent formula results

Question

I am new to PowerPivot and am still learning it's limitations.

I have a formula I am using to created an additional column inside of the
PowerPivot Table that shows an inconsistent results. <o:p></o:p>

Here is my formula.<o:p></o:p>

=IF((TABLE[ForecastedImpactDate]-TABLE[ReportedClosedDate])>30,"F","")<o:p></o:p>

And below is the result set. It is calculating a blank ReportedClosedDate
and that is an error.<o:p></o:p>

If I attempt to use the "IsBlank" function like this:

=IF(ISBLANK(TABLE[ReportedClosedDate]),"",IF((TABLE[ForecastedImpactDate]-TABLE[ReportedClosedDate])>30,"F","")<o:p></o:p>

Power Pivot throws a syntax validation error.

Any guidance you can offer will be greatly appreciated.

Thank you,

- Merry Pettijohn

Answer 1

Are your blank cells empty or zero length strings?  I've had this problem myself and it turned out I had a zero length string.

Answer 2

i just rebuilt your sample and this calculation worked just fine for me:

=IF(ISBLANK('TABLE'[ReportedClosedDate]); 
    ""; 
    IF(INT('TABLE'[ForecastImpactDate]-'TABLE'[ReportedClosedDate])>30; 
        "F"; 
        ""))

hth,
gerhard

---

- www.pmOne.com -

Answer 3

hi can you please check the below forum for your reference.

http://www.excelforum.com/excel-worksheet-functions/614583-inconsistent-formula-error.html