Blog Post
MarkBird
2 years agoContributor III
Hey Jack
Is it possible to pass values from a cube view into a custom calculate function?
I've tried a few variances of the code below but nothing I've come up with has worked.
GetDataCell(BR#[BRName=MyDynamicCalcs, FunctionName=CalculateCustomVariance, Col1=CVC(Col2), Col2=CVC(Col1)]):Name(Custom Variance)
At the moment I am just trying to return a variance between the two values. But if I manage to prove the concept then my calculation will be a bit more advanced, hence why I'm not using the standard variance formulas.
Regards,
Mark