Divide gives incorrect value

[Anonymous]

Hi,

  I did some expression as follows

num($(vACD_HoldTime)/$(vACD_Handle_Time),'###.###')     gives 2.000 value.

based on the my analysis vACD_HoldTime gives 0 value and vACD_Handle_Time gives 40 value.when we do divide function it has to display 0 but it shows 2.000 value. Please help me,

Thanks,

[PrashantSangle]

Hi,

If possible post your application??

if not then post $(vACD_HoldTime) and $(vACD_Handle_Time) variable expression..

Regards

[Anonymous]

Hi max,

  Thanks for your reply,App size is huge,

My formulas are

vACD_HoldTime=sum({<PeripheralCallType = {'2'}>} HoldTime)

vACD_Handle_Time=$(vACD_TalkTime)+$(vACD_WorkTime)+$(vACD_HoldTime)

Thanks,

[PrashantSangle]

Hi,

Are you using it in chart or text Object?

Also check individually vACD_HoldTime and vACD_Handle_Time in text object.

Regards,

[prieper]

Suggest to

a) leave away for a moment the formatting (NUM)

b) enter both parts with "="-sign into a textobject and check the resulting values manually on correctness/plausibility.

c) if both correct, the result should be as well.

HTH Peter

[#6 · Accepted solution]

I guess i the problem is a missing bracket, but without data we can only guess

sum({<PeripheralCallType = {'2'}>} HoldTime)  / $(vACD_TalkTime) + $(vACD_WorkTime) + $(vACD_HoldTime)

When dividing and multiplying with variables, always make some outer brackets to be safe, even if not needed:

try

/e fixed

num(

     ($(vACD_HoldTime)) / ($(vACD_Handle_Time))

     ,'###.###,')

It could also be caused of a one to many data situation, as the first variable includes a sum aggregation and the second doesn't - or probably double data entries which arent shown when getting the data in a listbox without unique ID

[Anonymous]

Hi marcus,

  Thanks for your reply.its working fine.Yes its brackts issue.

Now i got currect result.

Thanks,