UnitPrice Error

Suds

I have a mysterious problem where part of a report does not return a value for the unit price.

I have emplimneted a simple IF statement:

  IF Quantity = 0 THEN
    UnitPriceToPrint := ROUND(AmountExclInvDisc / 1,0.00001)
  ELSE
    UnitPriceToPrint := ROUND(AmountExclInvDisc / Quantity,0.00001);
END;

but the report displays a 0 if Quantity=0. I've checked visibility expressions on the indvidual cell, row and column and haven't found anything that should effect the visibility (such as if Quatity=0 than True).

Any help would be much obliged.

Cheers,

Suds

lvanvugt

Wat is the value of UnitPriceToPrint when Quantity = 0?

Suds

the value should be the unit price of a specific item we have in our catalogue.

Kc_Nirvana

Suds wrote:

I have a mysterious problem where part of a report does not return a value for the unit price.

I have emplimneted a simple IF statement:

  IF Quantity = 0 THEN
    UnitPriceToPrint := ROUND(AmountExclInvDisc / 1,0.00001)
  ELSE
    UnitPriceToPrint := ROUND(AmountExclInvDisc / Quantity,0.00001);
END;

but the report displays a 0 if Quantity=0. I've checked visibility expressions on the indvidual cell, row and column and haven't found anything that should effect the visibility (such as if Quatity=0 than True).

Any help would be much obliged.

Cheers,

Suds

The value 0 must be in field AmountExclInvDisc because if it is not possible to divide anything by zero

lvanvugt

Suds wrote:

the value should be the unit price of a specific item we have in our catalogue.

OK, but what I mean with my question "What is the value of UnitPriceToPrint when Quantity = 0?" is: when you execute the report and you get to your code ...

IF Quantity = 0 THEN
    UnitPriceToPrint := ROUND(AmountExclInvDisc / 1,0.00001)
  ELSE
    UnitPriceToPrint := ROUND(AmountExclInvDisc / Quantity,0.00001);
END;

... what is the value of UnitPriceToPrint when Quantity = 0? Did you try to debug and see what the value of UnitPriceToPrint is in that case?

Suds

Kc: I can get the AmountExclInvDisc to print when the quantity is zero which is why this is stumping me. The AmountExclInvDisc is always a positive number and not conditional on Quantity either.

Ivan: It returns a Zero, or how i set up, a blank when there should always be a positive number.

lvanvugt

Then:

Wat is the value of AmountExclInvDisc when Quantity = 0?

Suds

AmountExclInvDisc = a positive, displayable value that indicates an items cost when Quantity = 0

lvanvugt

OK, I rest my case (I ran out of options now). :-#