topic If Match Statement in App Development

If Match Statement

New-here1 — Thu, 25 Jan 2024 14:15:33 GMT

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

Re: If Match Statement

Digvijay_Singh — Thu, 25 Jan 2024 14:26:12 GMT

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

Re: If Match Statement

BrunPierre — Thu, 25 Jan 2024 14:32:29 GMT

Try

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

RecordID is unique for each row in the table

Re: If Match Statement

New-here1 — Thu, 25 Jan 2024 14:50:17 GMT

This worked! Thank you 🙂