Glad I found this group from the conference. I am trying to answer what I think should be a simple question in Analytics: How are my current sales for a performance and how does that compare to the performance budget that we entered in the performance setup screen in Tessitura?
There is an option in Analytics to pull "Budget Amount", but the usage only appears to show the correct amount when used in a pivot table and only when placed in a row. If I put it in the value section, the amount is not correct. Does anyone know why [Budget Amount] when placed in the rows section shows the correct amount, but behaves differently and displays incorrect amounts when its placed in the values section in the pivot table or in anything else?
Amy I took this problem to the 10 minute solution center at the Conference and met with Peter Nelson. He said there is a bug with this and was going to send me a formula that would fix it. I have not heard from him yet. I am experiencing the same problem of multiplying when I include performance dates as a row. I have budget amount as a value and if I turn off the date row the budgets are correct. This is all I have for the formula [Total Budget Amount].