Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with my second calculation (Acummulative value), the problem is I can not figure out how to obtain my second divide number (Num2). So I had to created a new table where I had that calculated my second number which divide my (Num), I Attached a Sample Excel File Within a qvf example plus an image with what I want to obtain in the final result.
Note : Field 2 = "Value 1" and Exclude Nulls Values into "Field 1".
Thannks !!!
Accepted Solutions
In your attached QVF file, there is no Num2 info. May be try like below
Sum(Total<Period> Aggr(Rangesum(Above(Count({<[Año_Creacion_SS]={'$(vAñoMax)'},
[Field 2]={'Value 1'},[Field 1]-={'-'}>}
Distinct ID&[Field 1]),0, RowNo())), Period))
You can alter the expression based on ur requirement
In your attached QVF file, there is no Num2 info. May be try like below
Sum(Total<Period> Aggr(Rangesum(Above(Count({<[Año_Creacion_SS]={'$(vAñoMax)'},
[Field 2]={'Value 1'},[Field 1]-={'-'}>}
Distinct ID&[Field 1]),0, RowNo())), Period))
You can alter the expression based on ur requirement
