Compare time from timespan data for logical operators

HI , I've a timeSpan column data in the form of HH:MM: SS.xxx. I'd like to use a normalization operation for data visualization as follows: Sum([ValueY])/Sum(If[TimeX]='11:45:00.000', [TimeX],0) over (All[TimeX]) But I get an error /warning which means it's unable to compare the [TimeX] values to absolute time 11:45:00.000 which is a value in the column. Could someone help me understand how to use logical comparators with timestamp data? Error: Invalid type for function call '='. I've to use an inverted comma for the absolute timestamp or else Spotfire returns an expected error.

(1) Answer

Login