Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm verifying a report and was shown that the total tickets sold is 89.
In a pivot table object created in QS, it appears that the summation is wrong.
Btw, the rest of the summation of other groups are correct.
Could anyone advise where could have possibly caused the "glitch".
Thanks a 10**7!
Regards,
Alloy
Try
if (dimensionality()=0, sum(aggr(expression,dimesnion)),expression)
or
if (dimensionality()=0, sum(total Sales),Sum(Sales)
Hi Everyone,
My requirement I have Duration column like Below.
duration second's
00:00:28
00:00:28
00:00:28
00:00:29
00:00:29
00:00:29
When I Trying to sum i am getting 00:00:57
Can any one help me sum the above seconds