Skip to Content
avatar image
Former Member

Not able to calculate average and maximum

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 16, 2017 at 11:13 AM

    Create V TCA time as dimension.

    V TCA Time=[TCA time]

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

    Add comment
    10|10000 characters needed characters exceeded