topic Re: total in dimension and mesure on straight table in App Development

total in dimension and mesure on straight table

simoevry — Sat, 16 Nov 2024 04:29:54 GMT

Hi guys,

I've problem with total If someone here could helpme .

this is my expression :

((MIN(Valeur)-Above(Max(Valeur))))/100

thank you !!

sunny_talwar — Wed, 02 Oct 2019 12:15:02 GMT

What exactly is the issue? Can you elaborate with an example from the image you have posted?

simoevry — Wed, 02 Oct 2019 13:38:28 GMT

Hi Sunny

Normally I must got this result in total columns for example : 115,04+99,20=214,20

sunny_talwar — Wed, 02 Oct 2019 14:06:54 GMT

Try this

Sum(Aggr(((Min(Valeur)-Above(Max(Valeur))))/100, [Descri], [MyDate_2], [hour1]))

simoevry — Wed, 02 Oct 2019 14:55:18 GMT

It's works for me thank you so much Sunny 😊

simoevry — Wed, 02 Oct 2019 15:18:00 GMT

I still have this issue when I wanna Deselect the selection, I 've seen the total not correct with negative value bellow

attachement :

sunny_talwar — Wed, 02 Oct 2019 15:23:21 GMT

What does the total need to show? Sum of rows?

simoevry — Wed, 02 Oct 2019 15:29:33 GMT

I need both of them

sunny_talwar — Wed, 02 Oct 2019 15:37:58 GMT

Both of them? What do you mean?

simoevry — Wed, 02 Oct 2019 15:57:37 GMT

I need to show total row and columns It's work but when I deselect the selection [Hour1], I got negatives values.

You can find the attachement bellow.

sunny_talwar — Wed, 02 Oct 2019 16:06:51 GMT

I understand what you mean, but what I am not sure about is the correct value? What exactly does it need to show (value)?

simoevry — Wed, 02 Oct 2019 16:18:57 GMT

I wanna just total value with correct result not with negative result as a picture on the last post .

Thanks sunny .