I'm experiencing the same issue - used to be able to pull this info without a problem, but now getting blank data for the dependent columns. Has anyone else been able to resolve this? Thanks, Andrew

Does anyone have any guidance on getting Payroll Results Real Time SA for OTBI, or ultimately, do we have to build these reports in BIP?

Much needed - need a way to audit who makes changes to reports and the folders. Upvoted.

same issue here - our IT dept updated MS Word this week. Worked for a day without issue, then the following day the same error. Had to disable it as unable to open Word at all (previously I could get in eventually by closing and reopening 2-3 times. But not since the update.

Thank you so much Nathan, that looks like it worked for me: CASE WHEN ((YEAR("Payroll Period"."End Date") - YEAR("Payroll Period"."Start Date")) * 12 + (MONTH("Payroll Period"."End Date") - MONTH("Payroll Period"."Start Date")) = 0 ) AND (DAY("Payroll Period"."Start Date") <= 12 AND DAY("Payroll Period"."End Date") >= 12)…

Not sure if it was the best approach, but I was able to get this working by dividing the headcount by the count of ethnicities listed when more than one is selected. I provided a sample below: It appears to be working where those showing as 'Two or More' will have a headcount of 1 vs 2+. As I said, I'm not sure if it was…

Thank you so much - that fixed my issue.