Variable not working in setanalysis

[#1]

Hello All,

Can any one please answer me why the below expression is not working in pivot table

count( if($(vTime1) > 34600, articleId))

dimension is MonthYear

Note : $vTime1 =

(Subfield(Interval($(vSum1),'hh:mm:ss'),':',1)*60*60)+

(Subfield(Interval($(vSum1),'hh:mm:ss'),':',2)*60)+

(Subfield(Interval($(vSum1),'hh:mm:ss'),':',3))

[Anonymous]

Hi Divya

Try using else condition and check the expression again like this

count( if($(vTime1) > 34600, articleId,'less than 34600'))

Regards

Harsha

[#3]

Try using without $() like the below

=(Subfield(Interval(vSum1,'hh:mm:ss'),':',1)*60*60)+

(Subfield(Interval(vSum1,'hh:mm:ss'),':',2)*60)+

(Subfield(Interval(vSum1,'hh:mm:ss'),':',3))

count( if(vTime1 > 34600, articleId))

[goncalo_ricardo_pereira]

Hello Divya,

Perhaps you want something like this:

count({$<Time_Field={">=$(=num($(vTime1)))"}>} articleId)

Best Regards.

Gonçalo Pereira