You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Not able to calculate data using Groovy

Accepted answer
171
Views
29
Comments
edited May 8, 2023 6:36PM in Planning 29 comments

Summary:

I am trying to calculate discount using groovy but data is not being calculated. BR is attached Run after save.

Form Layout.


Content (required):

Set<String> costCenter = []

operation.grid.dataCellIterator("A511101").each { 

DataCell cell -> if(cell.edited) {

   costCenter << cell.getMemberName("Cost Center")

     println("CC: $costCenter") // Able to see Cost Center in Jobs

DataCell ab = cell.crossDimCell("A511102")

     println(cell.data*0.1) // Able to see Calculated data in Jobs

   ab.data=cell.data*0.1 // Not able to save it

  }

}

I am able to see the calculated figure in println but it doesn't load it in essbase. What could be wrong in this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!