Issue in FN01 Universe After February Fin Data Close

[Jennifer Henry]

Hi all,

I am running a monthly spending report on a set of internally funded research grants and one of my columns is not populating. In my query, using the FN01 universe, data for one of my measures is no longer being retrieved (column name "transfer"). This column should populate as either $15,000 or $60,000 but I'm getting $0 for each of the 260+ entries. However, there is a "total" line for this column, and that figure is populating correctly.

I should also note that I ran the original query that was sent to me ~6 months ago and am having the same issue. Additionally, I've duplicated this query to make 5 additional reports (all modified to represent a different set of P/Gs) and each of these reports is experiencing the same issue.

This measure, named "transfers" is based on the following function: =If([Account Grp GASB Descr]InList("Other non-mandatory");[Sum of Dollar Amount];0)

I'm happy to send this report to anyone's BI inbox if you feel you can assist.

Thank you!

Jen

[Jennifer Henry]

Thank you very much Deb Lennington, Samuel Russell, and Bill LaCroix for your help!