Skip to Content
G G

Value from a table in a cell


Hi all,

I have this table

The last colum (Max) is shows the max value from column Count.

Now I need to show the the max value (from any row as is the same for all of them) in a cell object. But when I do that get a 1 for the value because the Period is not used in the cell. So the aggregation is wrong.

Is there any way to solve this?

I tried using Max in Report but didn't work.

Thanks!

Capture.PNG (23.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 09, 2015 at 07:32 AM

    Finally solved it using cells in the Bex Query.

    Thank you all for your help.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 10:29 PM

    HI Pepe,

    try using Max([Count] ForEach ([Period]) ) In Report,

    CHeers,

    ROgerio

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member G G

      IS it 1+Previous(Self)?

      IF so,

      try changing the Count to = 1 ForEach ([Period]) + Previous(Self) ForEach ([Period]),

      snd For Max use Last([Count]) In Report,

      CHeers,

      ROgerio

  • Jan 09, 2015 at 04:19 AM

    Hi Pepe ,

    Use count function for period to find the count like below:

    =Count([Period]) In Report

    Regards

    Sheetal Sharma

    Add comment
    10|10000 characters needed characters exceeded