Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

KPI object expression

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

Labels (1)
1 Solution

Accepted Solutions
acrodrigues03
Partner - Contributor III
Partner - Contributor III

Please, try something like this:

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

View solution in original post

2 Replies
acrodrigues03
Partner - Contributor III
Partner - Contributor III

Please, try something like this:

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

shamitshah
Partner - Creator
Partner - Creator
Author

Thanks that works.