Skip to Content
0

Not able to calculate average and maximum

Nov 13, 2017 at 01:26 PM

31

avatar image
Former Member

Hello,

I have created a report like below
1.png

Now what I am looking for is average for each Instrument grouping (final value only) as below-
2.png

But, I am not able to calculate the average and the maximum for each Instrument grouping.

Tried

=Average([TCA time]) In ([Live tag].[Transaction Number];[Instrument Grouping] ) and various combinations with foreach without any success.


Could somebody please help?


Regards,
Sonal

1.png (18.5 kB)
2.png (22.1 kB)
rrp4v.png (28.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Nov 16, 2017 at 11:13 AM
0

Create V TCA time as dimension.

V TCA Time=[TCA time]

Later use =Average([V TCA time]) in the table to get the average.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

TCA Time is already a dimension having the following formula-

=[Calculated TCA time] ForEach ([Live tag].[Transaction Number] )

PS- [Calculated TCA time] is a dimension too which calculates time spent in seconds between 2 dates for each transaction number.

Still, I tried with what you suggested. No success.

0

can you share the screenshot of Instrument Grouping and TCA time objects in one table.

0
Former Member

I do not show calculated TCA time in report as it creates multiple entries.
vi5kq.png (26.4 kB)
0