topic Finding issue to get common id's between two years and calculate the count using p() in App Development

Finding issue to get common id's between two years and calculate the count using p()

April1234 — Fri, 15 Nov 2024 21:00:24 GMT

I am trying to find the count of common id's from two years using P(), but it shows issue with the calculation

using the calculation like this ,Count({<ID=p({<year={'2022'}>})>*p({<year={'2023'}>})>}distinct ID)

But issue here is , it shows increase in values initially in a table with all the locations specified but shows correctly when a particular location is selected.

Any help here to fix the logic to show same numbers with or without selection of location?

Thank you!

Re: Finding issue to get common id's between two years and calculate the count using p()

MatheusC — Thu, 11 Apr 2024 18:44:13 GMT

@April1234
try this:

Count({<year={'2022'},ID=P({<year={'2023'}>}ID)>}distinct ID)

Regarts, Matheus

Re: Finding issue to get common id's between two years and calculate the count using p()

April1234 — Thu, 11 Apr 2024 19:52:32 GMT

It is very close to the numbers . I gave a try swapping the numbers and it worked.

Count({<year={'2023'},ID=P({<year={'2022'}>}ID)>}distinct ID)

Thank you so much Matheus for the logic.