Hello, everyone.
I am new to posting on this forum, but have used it in the past to solve some of my CR 2008 issues. Thanks for that!
I have inserted a calcuated member column in a cross tab, and I am trying to add some columns together using the GridValueAt formula. As you can see in the image, I have three summarized fields. The Budget Amount and Forecast Amount fields have a summary of MAX, and the Contract Value is a regular summary field. As you can see, the calculated member is working correctly for Budget Amount and Forecast Amount. It is when I try to use the same formula for the Contract Value that I get the error you see in the image. The value coming in from the database is zero. I am using this formula:
Gridvalueat (2,0,2) + Gridvalueat (2,1,2) + Gridvalueat (2,2,2)