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:
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! Go to Solution.
Are you looking for something like? IFS(ISNOTBLANK([Avance Real]),SUM(SELECT(...)))
Following
Are you looking for something like? IFS(ISNOTBLANK([Avance Real]),SUM(SELECT(...)))
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |