Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would need some help with a set analysis expression.
My source data is:
I have a variable named vFecha = 20150120
Would need an expression that calculates the sum of imp by DES_NEGOCIO (dimension in graph) for records that:
Selected records should be highlighted in yellow:
Thank you very much.
-----------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------
Hola,
necesitaría ayuda con una expresión de set analysis.
Mis datos de origen son:
Tengo una variable llamada vFecha = 20150120
Necesitaria una expresion que calculase la suma de imp por DES_NEGOCIO (dimension en el grafico) para los registros que:
Los registros seleccionados deberían ser los resaltados en amarillo:
Muchas gracias.
you wanted the count of DES_NEGOCIO on the basic of PK rite??
Would need an expression that calculates the sum of imp by DES_NEGOCIO (dimension in graph) for records that:
Here you have txo examples and the solution of each one:
would be possible to solve it using Firstsortedvalues function?
yes I think so, try with it once
Hi,
I have created a new field PK_FECMODIF (PK & '-' & FEC_MODIF AS PK_FECMODIF).
I am able to find which values of PK_FECMODIF are the correct qith this expresion:
FirstSortedValue({<FLAG={'A'},FEC_MODIF={'<=$(=vFecha)'}>}PK_FECMODIF, -FEC_MODIF)
But then, im not able to create a expresion to get the sum of IMP for this PK_FECMODIF. I've tried this:
sum( {<
PK_FECMODIF={"=FirstSortedValue({<FLAG={'A'},FEC_MODIF={'<=$(=vFecha)'}>}PK_FECMODIF, -FEC_MODIF)"}
>} IMP)
But it doesnt work.
Can anybody help me?
Thank you.
hI,
Can anybody help me?
Thank you.