Error in Expression

[#1]

Good day,

I am trying to use this expression below, but it shows me that there is an error in the expression.

What i am trying is really simple, i want that QV count the networkdays between TS.CorrectOne and Date_Time1 that are equal or higher than 5.

count(distinct if(networkdays(avg(TS.CorrectOne),avg(Date_Time1)) >= 5 , TS.Voyage))

Is there any other posibility or am I doing something wrong?

Just for information, these two fields are not in the same table.

Regards,

[#2]

Any sugestion my friends?

Rgds,

Jorge

[Sokkorn]

Hi Jorge,

Try this if(networkdays(avg(TS.CorrectOne),avg(Date_Time1)) >= 5 , COUNT(DISTINCT TS.Voyage))

Regards,

Sokkorn

[#4]

Tks Sokkorn, but I already try this expression, the problem with this is that it gives me the total number and without the condition.

I am here trying to think in another condition expression, but i can't find any.

I will try to join these two fields into one table and create this expression in script, probably it will work.

[#5 · Accepted solution]

I found it, i use this formula and worked:

count(aggr(if(networkdays(avg(TS.CorrectOne),avg(Date_Time1)) >= 5,Count(distinct TS.Voyage)),Month,TS.Voyage))

Rgds,

Jorge