Overflow error (1 Viewer)

Infinite · Dec 21, 2016

Code:

Work: IIf([RT ID]="Amazon",IIf([RT Fulfillment Channel]="Amazon",0,[RT Gross Sales]+[RT Shipping Cost Received]/[RT Quantity]*0.15*[RT Quantity]),0)

I am trying to get that to work, but I am getting an Overflow error. No idea why. Does anyone have any idea why? Thanks!

boerbende · Dec 21, 2016

overflow means that the result is outside the specification of your variable. for example you have 8 bits (=256 max) but you result = 300. so what is work?
try to analyze the variables seperately.
By the way:
you divide by [RT quantity] and then multiply again. without brackets. So effect = 1

Ben

pbaldy · Dec 21, 2016

You can also get that error if dividing by zero. Is that quantity field ever zero...or Null? And did you mean to include it twice?

Ranman256 · Dec 21, 2016

You can't put a super large number in a variable defined as integer.
It must be LONG.

Infinite · Dec 22, 2016

pbaldy said:
You can also get that error if dividing by zero. Is that quantity field ever zero...or Null? And did you mean to include it twice?

That was the problem. There was about 15 records that had 0. After changing/deleting them it now works. Was about to smash my computer after the 10,000th time if seeing the Overflow error.

pbaldy · Dec 22, 2016

Happy to help.

JHB · Dec 22, 2016

Infinite said:
..Was about to smash my computer after the 10,000th time if seeing the Overflow error.

Like him in the video, (another E40)?

https://www.youtube.com/watch?v=ZhK2hZvN3l8

Overflow error (1 Viewer)

Infinite

More left to learn.

boerbende

Ben

pbaldy

Wino Moderator

Ranman256

Well-known member

Infinite

More left to learn.

pbaldy

Wino Moderator

JHB

Have been here a while

Similar threads

Users who are viewing this thread