Divide By Acummulate Value

[pgalvezt2021]

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 !!!

[MayilVahanan · Accepted solution]

Hi @pgalvezt2021 

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