Text Mode Question

Hi All,

Here is challenge for all of you text moders out there! I have been asked for a report that compares a two task custom form entries. The tasks are the same week to week, with the same custom field (Pristine). They want the report to show the entry from last week, this week, and then the difference. I created a project report and was able to get the first and second columns:

Last Week:

displayname=Pristine Last Week

listdelimiter=

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(CONTAINS("Enter Resyndication Qualified Unit Update",{name}),IF({plannedCompletionDate}<$$TODAYe-1w,IF({plannedCompletionDate}>$$TODAYb-1w,{DE:Pristine},"")))

valueformat=HTML

This Week:

displayname=Pristine This Week

listdelimiter=&#xfeff;

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(CONTAINS("Enter Resyndication Qualified Unit Update",{name}),IF({plannedCompletionDate}<$$TODAYew,IF({plannedCompletionDate}>$$TODAYbw,{DE:Pristine},"")))

valueformat=HTML

But, when I try to get the difference between these, it is not working:

displayname=Pristine Difference

listdelimiter=&#xfeff;

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(ISBLANK(IF(CONTAINS("Enter Resyndication Qualified Unit Update",{name}),IF({plannedCompletionDate}<$$TODAYew,IF({plannedCompletionDate}>$$TODAYbw,{DE:Pristine},"")))),"",SUB(IF(CONTAINS("Enter Resyndication Qualified Unit Update",{name}),IF({plannedCompletionDate}<$$TODAYe-1w,IF({plannedCompletionDate}>$$TODAYb-1w,{DE:Pristine},""))),IF(CONTAINS("Enter Resyndication Qualified Unit Update",{name}),IF({plannedCompletionDate}<$$TODAYew,IF({plannedCompletionDate}>$$TODAYbw,{DE:Pristine},"")))))

valueformat=HTML

I have broken down my valueexpression and everything works except the 'Pristine Last Week' calculation. If I replace that with a number, the rest of the code works. Any ideas would be appreciated!!