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

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?

0 7 338
7 REPLIES 7

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

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

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

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

I will find the Postโ€ฆ

@Aleksi_Alkio Thanks! Translate

Top Labels in this Space