Need help in Report creation

[DeepaMa1]

I need help in calculating Metrix based on Document Receive Date and Agency Submission Date. Both values are tracked via tasks within projects.

I would like to create a report and display below calculation:

IF Agency Submission Date <= Document Receive Date + 10 working days Then 'Compliant' else 'non-compliant'

Columns that I would like to display are:

Project Name

Document Receive Date

Agency Submission Date

Agency Compliance (Display 'Compliant' OR 'Non-Compliant')

Quarter (Based on Agency Submission Date)

Year (Based on Agency Submission Date)

Is it possible to display Project Name on the row and rest of the fields in columns?

Thank you in advance,

Deepa

[KellieGardner]

To accomplish what you need, you'll have to run a project report and then use text mode for your columns.

Example of how to get task details into columns on a project report using text mode.

displayname=Document Receive Date
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({name}="Document Receive Date",{actualCompletionDate})
valueformat=HTML

[DeepaMa1]

@KellieGardner thank you. Based on your code, I created below formula to display the value compliant and non-compliant. Unfortunately, value is not being displayed. Any thoughts on this? Thank you in advance.

displayname=KPI

listdelimiter=<div>

listmethod=nested(tasks).lists

Textmode=true

type=iterate

valueexpression=IF(({name}="Document Receive Date",ADDWEEKDAYS({actualCompletionDate},10) < IF({name}="Agency Submission Date",{actualCompletionDate}),"Compliant","Non-Compliant")

valueformat=HTML