How to identify/acknowledge a project is active from report dates

[Dallas Dye 2]

i recieve daily reports from 27 different projects, instead of updating a 2nd spreadsheet to swith projects from active to paused to invoiced, to complete, i would be time ahead if i can simply create an active project column that would be carried to all previous report dates to bring in all the information from the data table to the daily spotfire report.

 

 

step one build a calculated column using if function on dates that labels the row active project if the date is the same as today or previous date

 

the projects that didn't have an active report would be null

actualformula

 

case

when [Report Date]=Today() then "Today"

when [Previous Day]=[Report Date] then "Today"

Else "Not Today"

END

 

 

 

 

step 2, figure out a calculated column to apply the Active project on the last day (report day = today) to all previous reports of the active projects.

 

 

Thank you as alwasy TIBCO Community, you all are undefediated!

[Fabian Duerr]

(According to your text project 'a' should be 'active' as well)

1. Calculated column:

If(DateDiff('day',[Date],Date(2021,01,08))

[Dallas Dye 2]

Great catch on the project A, i used the last (status) over (project), it worked flawlessly, thank you fabd for saving days of my life!

[Fabian Duerr]

You are welcome :)