Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Context:
i create dimension for a table using this expressions:
in order to make calculations on the dimensions i used this expression:
(sum({<Concepto={'CLIENTES','ANTICIPOS A INTERCOMPAÑIAS'},ID_Clase=-{'WE'}-{'WA'}-{'WI'}-{'KA'},MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)
+
sum({<Concepto={'OTROS GASTOS POR AMORTIZAR','ANTICIPOS A PROVEEDORES','FUNCIONARIOS Y EMPLEADOS'},MONEDA,ID_Clase=-{'WE','WA','WI'},CME=-{'F'},FECHA_COMPEN={">$(=(Max(NUMMES_C))) <=$(=NUM(Today()+Year(today()+10)))"},NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)
+
sum({<Concepto={'ALMACEN DE REFACCIONES','EFECTIVO E INVERSIONES'},ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)
+
sum({<Cuenta={"=(Mid(Cuenta,1,4)=1288)"},ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR))/1000
calculations are fine, the problem come when i try to add or sum new values:
this is the google sheet i use:
in order to sum i use this expression, i add it to the main expression.
+
IF(MID(Cuenta,1,4)>=1101 AND MID(Cuenta,1,4)<=1101,SUM({<FechaBG2={'$(=MesC&AñoC)'}, ConceptoBG2 = {'CAJA'},SociedadBG2={'$(=Sociedad)'}>} ImporteBG2))
and all values dissaper
its there another or make a better expression to plus into my expression?
im pretty sure that the expression work, since i used in another sheet from google, i tried diferent ways, and im guessing that the problem on the expression is this
but i need that condition, cause it must sum only conceptoBG2 when the range of Cuenta its the same from dimesion