Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@April1234
try this:
Count({<year={'2022'},ID=P({<year={'2023'}>}ID)>}distinct ID)
Regarts, Matheus
@April1234
try this:
Count({<year={'2022'},ID=P({<year={'2023'}>}ID)>}distinct ID)
Regarts, Matheus
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.