Forum Discussion

Oscar's avatar
Oscar
Contributor
4 years ago
Solved

UD8 Calculate Variance Between Two Scenarios in Cube View

We are trying to calculate the variance between two Scenarios using an UD8 member. In Essbase, the calculation below works just fine, but in OneS it returns an error. Any improvement to the formula i...
Cube View
NicoleBruno's avatar
NicoleBruno
Valued Contributor
4 years ago

Hello! 

Does it need .CellAmount after the formula? 

Return api.Data.GetDataCell("S#Actual - S#TieOut12").CellAmount

I'm not the best at vb.net but this is what all my UD8 calcs have at the end so worth a shot. 

Oscar's avatar
Oscar
Contributor
4 years ago

Hi Nicole!

Thanks for the input, unfortunately, it fails to compile and returns the same error.