cancel
Showing results for 
Search instead for 
Did you mean: 

Value from a table in a cell

guillermo_m
Active Participant
0 Kudos


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!

Accepted Solutions (1)

Accepted Solutions (1)

guillermo_m
Active Participant
0 Kudos

Finally solved it using cells in the Bex Query.

Thank you all for your help.

Answers (2)

Answers (2)

former_member211423
Active Participant
0 Kudos

Hi Pepe ,

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

=Count([Period]) In Report

Regards

Sheetal Sharma

Former Member
0 Kudos

HI Pepe,

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

CHeers,

ROgerio

guillermo_m
Active Participant
0 Kudos

Hi Rogerio,

Thanks for your quick reply.

I tried that but didn't work. The problem is that the Count column has a formula using the previous function. So if I remove the Period I always get 1 for the count column.

Former Member
0 Kudos

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