Condition: "Variable1" is less than "Variable2 +2"

[#1]

Hi,

I would like to set up a "Count"-formular, that counts "ACDCaller" in case that "ACDDuration" is less than "ACDQueueTime" + 2.

I have tried the following, however it doesn't work:

Count(
     {
       <ACDDuration = {"<$ACDQueueTime"}+{'2'}>
     }
     ACDCaller
     )

Can you help me with this formular?

I thank you very much for your help!

Max

[swuehl]

Try

Count(
     {
       <ACDDuration = {"<$(ACDQueueTime)+2"}>
     }
     ACDCaller
     )

[sivarajs]

Count({<$(ACDDuration)={"=<($(ACDQueueTime)+2)"}>}ACDCaller)

[#4]

Unfortunately, this didn't work...

[#5]

Unfortunately, this didn't work...

[swuehl]

I assumed ACDQueueTime is a QV variable, but maybe it's another field in the same table as ACDDuration?

Then try like this:

Count(
     {
       <ACDDuration = {"=ACDDuration<ACDQueueTime+2"}>
     }
     ACDCaller
     )

[#7]

Sorry about that. ACDQueueTime, ACDDuration and ACDCaller are all fields of one single table.