KPI object expression

[shamitshah]

Hi,

I  get the right result for the following expression in a table:

=IF(OpenTime1 < time(time_of_md),0,Sum(NO_OF_TCKTS))

How can i get the same result in a KPI object?

I tried the following but it does not give the right result

Sum(Aggr(IF(OpenTime1 < time(time_of_md),0,Sum(NO_OF_TCKTS)),Store))

Thanks

[acrodrigues03 · Accepted solution]

Please, try something like this:

Sum({<[OpenTime1] = {"<$(=time(time_of_md))"}>} NO_OF_TCKTS)

[shamitshah]

Thanks that works.