Skip to Content

Problem *REC(EXpression= %Value%... ) Script Logic

Hello experts,

I have poste previously for a Script Logic I am doing, the problem that came up is that 0 Value come from my Scripting.

I have the next CODE:

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA = MXN

*XDIM_MEMBERSET SOCIEDAD = 1010

*XDIM_MEMBERSET HOTEL= MTYGA, MTYZV

*XDIM_MEMBERSET ZRELACIONCTACEBE = NA_ZREL

*XDIM_MEMBERSET SUPNOM = NA_SUPRH

*XDIM_MEMBERSET ZSTAGL = NA_ES

*XDIM_MEMBERSET OP_RRHH = NA_RH

*XDIM_MEMBERSET OP_SUPUESTOS = NA_SUP

*XDIM_MEMBERSET CUENTAS=0000650000, 0000650002

*FOR %T%=%PERIODO_SET%

*XDIM_MEMBERSET PERIODO=TMVL(-12,%T%)

*WHEN CUENTAS.IND

*IS "HIS"

*REC(EXPRESSION= %VALUE% *([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = %T%, CATEGORIA ="Sugerido")

*ENDWHEN

*NEXT

If in the Calculation I just left %VALUE% the value in the Scope will be saved in PERIODO %T% and Categoria= "Sugerido".

But when i Try to multipy by the inflation that is store as described in the code:

Sociedad= NA_CCC

CATEGORIA= REAL

CeBe= NA_CeBe

CECO= NA_CECO

CUENTAS= NA_ACC

MONEDA=MXN

......and so on

I get the value 0.

Next I post the log for the %VALUE% alone:

LGX:

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA = MXN

*XDIM_MEMBERSET SOCIEDAD = 1010

*XDIM_MEMBERSET HOTEL= MTYGA, MTYZV

*XDIM_MEMBERSET ZRELACIONCTACEBE = NA_ZREL

*XDIM_MEMBERSET SUPNOM = NA_SUPRH

*XDIM_MEMBERSET ZSTAGL = NA_ES

*XDIM_MEMBERSET OP_RRHH = NA_RH

*XDIM_MEMBERSET OP_SUPUESTOS = NA_SUP

*XDIM_MEMBERSET CUENTAS=0000650000, 0000650002

*XDIM_MEMBERSET PERIODO= 01.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE%, PERIODO = 01.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 02.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE%, PERIODO = 02.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 03.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE%, PERIODO = 03.2017, CATEGORIA = Sugerido)

*ENDWHEN

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2016-08-23 03:17:08

FILE:\ROOT\WEBFOLDERS\BPC_FIBRA_INN \ADMINAPP\OPERACIONES\TEST.LGF

USER:RBENAVIDES

APPSET:BPC_FIBRA_INN

APPLICATION:OPERACIONES

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:01.2016,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 4.00 ms. 7 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

7 RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7 RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 525.88

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 7714.54

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 895.02

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 7141.24

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 6572.94

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 2841.18

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 730.60

7 RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00 ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:02.2016,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 4.00 ms. 7 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

7 RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7 RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 10153.24

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 3258.52

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 5567.14

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 9182.98

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 10820.14

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 5910.48

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 2569.86

7 RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00 ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:03.2016,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 3.00 ms. 9 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :1.00 ms.

9 RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 9 RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 228.42

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 9896.74

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 3690.60

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 5227.02

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 7410.70

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 9895.40

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 4111.82

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 2138.00

Sugerido 10TYZV4450 10TYZV4450 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 839.66

9 RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00 ms.

SCRIPT RUNNING TIME IN TOTAL:15.00 s.

LOG END TIME:2016-08-23 03:17:22

The values displayed.

But when I use the first code i get all 0.00:

LGX:

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA = MXN

*XDIM_MEMBERSET SOCIEDAD = 1010

*XDIM_MEMBERSET HOTEL= MTYGA, MTYZV

*XDIM_MEMBERSET ZRELACIONCTACEBE = NA_ZREL

*XDIM_MEMBERSET SUPNOM = NA_SUPRH

*XDIM_MEMBERSET ZSTAGL = NA_ES

*XDIM_MEMBERSET OP_RRHH = NA_RH

*XDIM_MEMBERSET OP_SUPUESTOS = NA_SUP

*XDIM_MEMBERSET CUENTAS=0000650000, 0000650002

*XDIM_MEMBERSET PERIODO= 01.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = 01.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 02.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = 02.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 03.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = 03.2017, CATEGORIA = Sugerido)

*ENDWHEN

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2016-08-23 03:20:58

FILE:\ROOT\WEBFOLDERS\BPC_FIBRA_INN \ADMINAPP\OPERACIONES\TEST.LGF

USER:RBENAVIDES

APPSET:BPC_FIBRA_INN

APPLICATION:OPERACIONES

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:01.2016,1 in total.

REC :%VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION])

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 5.00 ms. 7 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 0 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

7 RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7 RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

7 RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00 ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:02.2016,1 in total.

REC :%VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION])

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 4.00 ms. 7 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 0 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

7 RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7 RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

7 RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00 ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:03.2016,1 in total.

REC :%VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION])

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 5.00 ms. 9 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 0 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

9 RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 9 RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4450 10TYZV4450 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

9 RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00 ms.

SCRIPT RUNNING TIME IN TOTAL:18.00 s.

LOG END TIME:2016-08-23 03:21:15

What am I doing Wrong to achieve the Math?

Regards.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 23, 2016 at 08:41 AM

    Are you sure that you have Inflation for PERIODO=TMVL(-12,%T%)????

    May be:

    *REC(EXPRESSION= %VALUE% *([PERIODO].[%T%],[SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = %T%, CATEGORIA ="Sugerido")

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.