Virtual column calculated if another column has value

Hi, 

I have a virtual column [Avance Acumulado Real]: 

 

SUM(SELECT(curvaS[Avance Real], 
AND (
([_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]),
([Id proyecto]=[_THISROW].[Id proyecto])
))
)

 

My view is like this:

Captura de pantalla 2023-12-22 a la(s) 15.18.41.png

How I can only calculate when I have values in column [Avance Real]

I have tried using ISNOTBLANK([Avance Real]) in 'Show_If', but I have a chart with values and the chart display every values.

I tried this, but not working

 

SUM(SELECT(curvaS[Avance Real], 
AND (
([_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]),
([Id proyecto]=[_THISROW].[Id proyecto]),
(ISNOTBLANK[Avance Real])
))
))

 

thanks

Solved Solved
0 2 176
1 ACCEPTED SOLUTION

Are you looking for something like?  IFS(ISNOTBLANK([Avance Real]),SUM(SELECT(...)))

View solution in original post

2 REPLIES 2

Following 

Are you looking for something like?  IFS(ISNOTBLANK([Avance Real]),SUM(SELECT(...)))

Top Labels in this Space