Compare time from timespan data for logical operators

[Sudhansu Mishra]

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.

[Gaia Paolini]

Hi

You cannot have an if statement where the true option is a timespan and the false option is an integer.

Try replacing the 0 option with TimeSpan("0")

Gaia