topic Re: counter for Above in App Development

counter for Above

c_pannese — Sat, 16 Nov 2024 18:54:34 GMT

hi,

i have a table like this:

i suppose to use a progressive number (like the last column) to using the Above function. The Above function should restart when Cod. Articolo change. I'm unable to create the couter

Thank you all!!

Re: counter for Above

rubenmarin — Sun, 22 Mar 2020 20:08:11 GMT

Hi, you can try with:

If(Above(TOTAL [Cod. Articolo])=[Cod. Articolo], Above(TOTAL [Counter])+1, 1)

Set Counter as the label of the expression...or change the name of the label and the expression to the same name.

Re: counter for Above

c_pannese — Tue, 24 Mar 2020 13:25:28 GMT

it doesn't work correctly.. It shows the null values in the other columns and doesn't work when no Article are selected.

Thank you

Re: counter for Above

c_pannese — Tue, 24 Mar 2020 13:34:38 GMT

Using your help i'm trying to using directly this measure without passing the "Counter":

If(Above(TOTAL [Cod.Artcolo])=[Cod.Articolo],
above(total (today()-1+ceil(Column(3))))+ceil(Column(3)),
today()-1+ceil(Column(3)))

but it doesn't work too.

Re: counter for Above

rubenmarin — Tue, 24 Mar 2020 14:07:31 GMT

I will need a sample to test what you are saying about "null values in the other columns" and about "no Article are selected".

Sample attached, it seems to work in there.

Re: counter for Above

c_pannese — Tue, 24 Mar 2020 21:06:29 GMT

the condition is "if (column(1)>0,..."

Without the condition it shows all the zero values.

The column "test " is

if(COlumn(1)>0,
If(Above(TOTAL [Cod.Articolo])=[Cod.Articolo],
above(total (today()-1+ceil(Column(3))))+ceil(Column(3)),
today()-1+ceil(Column(3))))

but doesn't work.

Thanks

Re: counter for Above

rubenmarin — Wed, 25 Mar 2020 08:14:08 GMT

Hi, Are you using this same expression? In your expression you are using today() and ceil(colum(3)), Are you asking about a different expression? why test expression matters?

Your initial post asks about an incremental counter when Cod. articolo is the same than above, and the expression I proposed was:

If(Above(TOTAL [Cod. Articolo])=[Cod. Articolo], Above(TOTAL [Counter])+1, 1)

Which I tested, also with nulls and a dimension before, and works (sample attached) maybe you need to use [Cod.Articolo] instead of [Cod. Articolo]?

If it doesn't works I will need a real sample (not just a capture) to check why isn't working. It can be done with inline data to not share all the app.

Regards

Re: counter for Above

c_pannese — Wed, 25 Mar 2020 09:13:54 GMT

Initially i supposed to use the counter but after your post i've tried the counter and,using the same logic, another formula.

Actually i understood chat i nerd the second formula with column(3).

I hope if the couter works the other formula works too , but in my table the counter doesn't work correctly.

Maybe i should write a New post..

Re: counter for Above

rubenmarin — Wed, 25 Mar 2020 16:37:30 GMT

As you wish about opening a new post.

If you can upload a sample that shows the issue and why the counter doesn't works I can take look, so far I don't know why is working because in my sample works and I can't imagine why it's showing nulls in yours.

Re: counter for Above

c_pannese — Sun, 29 Mar 2020 15:24:39 GMT

I had to chance the strutture of my table and now works!

Thank you!