Power Formulas in databuffer
Hi Team,
Could you please let us know if it's possible to use the function math.pow in a databuffer? and if yes, which is the correct syntax?
As for example Dim resultDataBuffer As DataBuffer = a...
Forum Discussion
JackLacava
OneStream Employee
OneStream EmployeeYou cannot use math.pow like that, try with the ^ operator, but if i remember correctly in Calculate formulas (and hence in GetDataBufferUsingFormula, which is effectively a subset of that) you're limited to the 4 main operators ( + - * / ).
A workaround is to go cell by cell and use math.pow on the .CellAmount property, but you'll have to add "Imports System.Math" at the top - so it will have to be done in a Business Rule.