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

expressions
(Fabian Weller) #1

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) #2

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

(Fabian Weller) #3

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

(Aleksi Alkio) #4

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

(Steven Coile) #5

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

(Aleksi Alkio) #6

I will find the Post…

(Aleksi Alkio) #7

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

(Steven Coile) #8

@Aleksi_Alkio Thanks! Translate