You’re offline. This is a read only version of the page.
Announcements
162
Good day!
asking for help regarding to display gallery .
scenario: What I want to do is to count duplicate year with the same person and make as one(1) . please see image below.
thank you and advance
Hi @DHAGZ ,
Please try:
Share
Report
All responses (
Answers (
ForAll(Distinct(Table({LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2023"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2022"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2023"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2023"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2022"})
,YEAR),{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YESR:Result,COUNT:CountIf(
Table({LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2023"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2022"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2023"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2023"},
{LASTNAME:"A",FIRSTNAME:"B",MI:"S",YEAR:"2022"}),YEAR=Result
)})
Best Regards,
Dezhi
