Bug in SUM(LIST) expression? I have a Ref co...

[Fabian_Weller]

Bug in SUM(LIST) expression?

I have a Ref column [Month]. I want to do a SUM with SUM([Month][Time])

[Time] is decimal. In the expression builder the result is correct. For each Month I get the right values. Jan = 10.5, Feb = 20.0, March = 15.0, and so on But in the App it sums the results of every month and adds the result of January. Might this be a bug?

[Aleksi_Alkio]

Try to use SUM(SELECT([Month][Time],TRUE))

[Fabian_Weller]

@Aleksi_Alkio Thank you very much, that works. Can you explain why SUM([Month][Time]) does not work propper?

[Aleksi_Alkio]

I believe the format has just designed to work in that way. I need to check this.

[Steven_Coile]

@Aleksi_Alkio I’m unfamiliar with the [Month][Time] construct (2 adjacent column references with no period between). What does it do?

[Aleksi_Alkio]

I will find the Post…

[Aleksi_Alkio]

https://plus.google.com/u/0/116466377064499551355/posts/2pYP8FvUucn

[Steven_Coile]

@Aleksi_Alkio Thanks! Translate