Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I've problem with total If someone here could helpme .
this is my expression :
((MIN(Valeur)-Above(Max(Valeur))))/100
thank you !!
Try this
Sum(Aggr(((Min(Valeur)-Above(Max(Valeur))))/100, [Descri], [MyDate_2], [hour1]))
What exactly is the issue? Can you elaborate with an example from the image you have posted?
Hi Sunny
Normally I must got this result in total columns for example : 115,04+99,20=214,20
Try this
Sum(Aggr(((Min(Valeur)-Above(Max(Valeur))))/100, [Descri], [MyDate_2], [hour1]))
It's works for me thank you so much Sunny 😊
I still have this issue when I wanna Deselect the selection, I 've seen the total not correct with negative value bellow
attachement :
What does the total need to show? Sum of rows?
Both of them? What do you mean?
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.