topic Re: Top function not functioning as intended in App Development

Top function not functioning as intended

JohnSpot — Wed, 27 Oct 2021 15:41:11 GMT

Hello all,

Thanks in advance for the time you will dedicate to my topic !

I am trying to retrieve the first value of a column (which looks straighforward 🙂 ) and elected to use the Top function.

Super simple. But when I display Top(saEntite), it does not work but displays invalid function.

Is there something obvious I am missing ?

Would anyone have any advice ?

Thanks a lot !

Cheers,

Guillaum

rubenmarin — Sun, 31 Oct 2021 08:38:09 GMT

Hi, I'm not suere why it doen't works, if you have a field Dim1 with values A,B,C and you use Top(Dim1) it will show 'A' on all rows.

Note that this is an expression, maybe you are trying to use it as dimension instead of as expression?

As a Dimension it could be something like :=Aggr(If(Dim1=Top(Dim1), Dim1), Dim1)

JohnSpot — Tue, 02 Nov 2021 11:16:17 GMT

Holly molly,

You make life look easy.

It worked. Thanks a lot !