[line 156]: Error in a!forEach() expression during iteration 1: Expression evaluation error in rule 'ino_isblank' at function 'isnull' parameter 1 [line 2]: Invalid index: Cannot index property 'adherencePercentage' of type String i

a!localVariables(
  local!monthYearList: a!forEach(
    items: ri!dateCategoryList,
    expression: {
      month: month(fv!item.value),
      year: year(fv!item.value),
      day: day(fv!item.value),
      name: fv!item.name
    }
  ),
  {
    a!lineChartField(
      label: "Conformance",
      categories: ri!dateCategoryList.name,
      series: a!chartSeries(
        label: "Conformance",
        data: a!forEach(
          items: local!monthYearList,
          expression: a!localVariables(
            local!month: fv!item.month,
            local!year: fv!item.year,
            local!day: fv!item.day,
            local!week: fv!item.name,
            local!taskProdutionList: index(
              ri!taskProdutionList,
              where(
                a!forEach(
                  items: ri!taskProdutionList,
                  expression: if(
                    ri!selectedDateRange = cons!INO_DATE_RANGE_16_WEEK,
                    and(todate(fv!item.weekDate) = todate(local!week)),
                    and(
                      month(fv!item.weekDate) = local!month,
                      year(fv!item.weekDate) = local!year,
                      if(
                        or(
                          ri!selectedDateRange=cons!INO_DATE_RANGE_MTD,
                          ri!selectedDateRange=cons!INO_DATE_RANGE_WTD
                        ),
                        day(fv!item.weekDate) = local!day,
                        true
                      )
                    )
                  )
                )
              ),
              {}
            ),
            
            if(
              rule!INO_isBlank( local!taskProdutionList.adherencePercentage ),
              null,
              round(average(local!taskProdutionList.adherencePercentage), 0)
            )
          )  
        ),
        links: a!forEach(
          items: local!monthYearList,
          expression: a!dynamicLink(
            saveInto: {
              a!save(
                ri!selectedMonth,
                fv!item.month
              ),
              a!save(
                ri!selectedYear,
                fv!item.year
              ),
              a!save(
                ri!selectedWeek,
                /*todate(fv!item.name)*/
                fv!item.weekDate
              ),
              a!save(
                ri!selectedDay,
                fv!item.day
              )
            }
          )
        )
      ),
      xAxisTitle: if(
        or(ri!selectedDateRange=cons!INO_DATE_RANGE_MTD, ri!selectedDateRange=cons!INO_DATE_RANGE_WTD),
        "Day",
        if(
          ri!selectedDateRange = cons!INO_DATE_RANGE_16_WEEK,
          "Week",
          "Month"
        )
      ),
      yAxisTitle: "Conformance",
      yAxisMin: 0,
      showLegend: false
    )
  }
)

  Discussion posts and replies are publicly visible

Parents
  • We can't see the whole error message (in general it's best to give a bit of a description in your post so we can understand what's happening / what you tried) - in general though, the "can't index property" error message means you're adding dot notation into a field that is a simple type (i.e. not a CDT, map, or record). Take a look at a place like line 51 to determine if the variable there is defined correctly.

Reply
  • We can't see the whole error message (in general it's best to give a bit of a description in your post so we can understand what's happening / what you tried) - in general though, the "can't index property" error message means you're adding dot notation into a field that is a simple type (i.e. not a CDT, map, or record). Take a look at a place like line 51 to determine if the variable there is defined correctly.

Children
No Data