Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I’m having trouble building a KPI in a straight table, since I need it to accumulate and reset whenever it encounters a different material code. Below is an example:
I need to generate the column "Unidades Acum" and I have tried the following formula:
rangesum(above(sum(Unidades),0,RangeSum(Above(if(only(CodMaterialSAP)=above(total CodMaterialSAP),1,0), 1, RowNo()))))
Do you have any idea? Thanks in advance!
Hola @charliota , one option is create the accumulation in script, using inter record functions like peek() and previous()
Example script :
This is the resulting table
Thanks for the response QFabian, but I need to do this on the Front-End since it has to be dynamic... any other option to do it at the object level instead of the script level?
Thanks in advance!
@charliota I almost forgot that we have accumulation as expression propertie!!!!!!
Así queda, como la acumulación aguanta hasta 2 dimensiones, pasé la fecha como expresión :
Thanks for the response, but it doesn’t work for me when I have 3 dimensions in the table. Any other idea?