Virtual column shows zero on edit view but on form view shows the calculated value

[Joaquin_Otero1]

Hi everyone!

I have a virtual column that has the following formula:

SUM ( SELECT ( User Stats Slice[Score], [User] = [_THISROW].[User] ))

It happens that the calculated value is shown correctly when I open the Form to edit that row but is zero when in Detail view.

I've tried with deactivating the Delta sync and the Quick sync options but didn't solve the problem.

Is like if it is behaving like a normal (not virtual) column.

I think this is a bug because it was working fine as I remember.

Any clues on this?

Thanks!

@Steve @TeeSee1 @Suvrutt_Gurjar @AleksiAlkio @WillowMobileSys 

[TeeSee1]

That is funny. What do you get in a Table view? Still zero?

[Joaquin_Otero1]

yes zero too

[TeeSee1]

The only thing I can guess is that it may have something to do with the slice.

But otherwise no clue...

[Joaquin_Otero1]

I've changed the virtual column formula and it works as expected but it's not the best way to do it.
I'm selecting now from the source table, not from the slice.

SUM (
SELECT ( User Stats[Score],
AND (
[User] = [_THISROW].[User],
[Date] >= ANY ( Filter US[Date since] ),
[Date] <= ANY ( Filtro US[Date till] )
)
)
)

Still wondering why the first solution (better I guess) is not working on Detail view. The slice has Add and Edit permission.