If Match Statement

[New-here1]

Hello,

I am looking to get a total value of courses completed on time in a KPI chart.. 

To get this, I think I need a IF MATCH statement.

Basically, if the (course end date) matches the (course estimated end date) then I would then want the number to show in the KPI so the code will go in the KPI chart

Hope this makes some sense

Thank you 

[Digvijay_Singh · Accepted solution]

I think the better way is to create an indicator in the script like below - 

If([Course End Date] = [Course Estimated end date] = 1,0)   AS [On Time Indicator]

and then in the chart, you can do something like this - 

Count({<[On Time Indicator] = {1}>} [Course ID])

Just an idea, your data model might need a tweak to make it work

[BrunPierre]

Try

=Count({$<RecordID={"=EndDate =EstimatedEndDate"}>}DISTINCT CourseID)

RecordID is unique for each row in the table

[New-here1]

This worked! Thank you 🙂