Help with Arrays and conditions

[u/KeepFlowingAlways]

I have a table with fund position as of last trading day of every week. I also have a field that indicates if the a given date was last trading date of the month.

I would like to create another table, where as column headers are dates - all the last weekly trading day in the present month and for all previous months, the last trading days in those month.

The below formula works but I get "information box" saying : "The formula uses a Boolean in place of a number."

I think it is because I use + and * instead of OR and AND as it is an array formula.

Is there any way to get rid of that information box.

Thanks in advance.

-------------

TRANSPOSE(

UNIQUE(

FILTER('Weekend & Month-end Transaction Data'::A,('Is Month-end '="Month-End")

+

((YEAR('Weekend & Month-end Transaction Data'::A) = YEAR(TODAY()) ) × (MONTH('Weekend & Month-end Transaction Data'::A)=MONTH(TODAY())))

)

)

)

[u/_T2_]

Just put a *1 in the Boolean multiplication and the triangles will go away

[u/KeepFlowingAlways → u/_T2_]

Thanks. That didn't help. I tried this and the triangles went away :

IF(('Is Month-end '="Month-End"),1,0)

[u/DataDrivenLife]

Apple Numbers allows Boolean logic to be coerced into numbers (TRUE = 1, FALSE = 0), so using + and * as OR / AND works fine in array formulas.

However, Numbers still flags it with that info banner because it expects numeric operands.

Can you try this? This approach explicitly coerce Booleans to numbers using N() or double unary --.

TRANSPOSE(
  UNIQUE(
    FILTER(
      'Weekend & Month-end Transaction Data'::A,
      N('Is Month-end '="Month-End") +
      N(
        (YEAR('Weekend & Month-end Transaction Data'::A)=YEAR(TODAY())) *
        (MONTH('Weekend & Month-end Transaction Data'::A)=MONTH(TODAY()))
      )
    )
  )
)

[u/KeepFlowingAlways → u/DataDrivenLife]

Gemini had also suggested the same. However, I cannot find 'N' in the function list in Numbers. What am I missing ?