Dear Experts,
We are implementing this script logic following the recommendations and definitions of the statements but it´s not working as is expected to be, so we are asking for some help
*XDIM_MEMBERSET COSTCENTER=%COSTCENTER_SET% // Here we are getting the member that is selected from the Current View
*SELECT(%AREAFUN%,"[FUNC_AREA]",COSTCENTER,"[ID]='%COSTCENTER_SET%'") // Here we are getting the property u201CFUNC_AREAu201D of the COSTCENTER member selected before and stored into the variable %AREAFUN% with the following sentence
*XDIM_MEMBERSET COSTCENTER=%AREAFUN%
*SELECT(%BECAS%,ID,PC_GLFA,"FUNC_AREA='%AREAFUN%' AND GL_ACCOUNT='7302010000' AND GL_ACCOUNT='7301020000'") //with this select we are filtering the accounts that have the same FUNC_AREA value that the one selected in COSTCENTER and that meet the GL_ACCOUNT property filters as well
*XDIM_MEMBERSET PC_GLFA = %BECAS%
*WHEN PC_GLFA // this is the account dimension
*IS P102 // this is an account member
// the following statement is not working, it should sum up all the values that come in the variable %BECAS%.
*ADD %SUMA%=['%BECAS%']
*REC(EXPRESSION=%SUM%,PC_GLFA="P104")
*ENDADD
*ENDWHEN
*COMMIT
Any of you have a recommendation to solve our problem??
Best Reagads.
Aldrin Liendo