Error on Printing Divided Values

Mclaren

Hi Guys,


I have to a get a value from Two values. If I want to get X I want to get it like Y/Z. There is an issue. If Y and Z are Zero the X value Prints like "#ERROR". If Both the values are Zero I want to get X also as Zero. Can any one provide me a solution on this. Any help will be appreciated.

Belias

this is math, not programming...
example:
if n <> 0 and m <> 0
n/m = x

if n= 0 and m <> 0
n/m = 0

if n<>0 and m = 0
division by zero: impossible

if n= 0 and m= 0
zero divided by zero: indefinite (i don't know if it's correct english)

the correct value for you should be ERROR (mathematically talking), but if you want zero if the division errors out, then just do

if m <> 0 then
  x := n/m
else
  x := 0;

Mclaren

Tx Belias.
How to write it under Value property of RTC Report?

Belias

with an IIF(....) statement...but it's simpler if you just do it in nav: calculate it in a variable, and show the variable in the report

Mclaren

Ya. U R Correct. But I have to perform Two functions. One is to Print X and One is IF Y and Z = 0 I have to print X also as 0. Please Belias Provide me a solution.

Belias

I already provided it: create "x" variable in nav, calculate it with the code i wrote above, put the variable in the right section in classic client, set the expression of a textbox in the rdlc as =Fields!x.Value

I don't know how to explain you more than this :-k

Mclaren

Hi I have tried this Codes to assign a value to DecPrice Variable.but Its executing the Else Part only.
XXXXX.GET;


XXXXX.SETRANGE("Qty",XXXXX."Qty");
DecCost := XXXXX."Cost" * XXXXX."YQuantity";
IF (XXXXX."Qty" <> 0) THEN
DecPrice :=(DecCost/(XXXXX."Qty"))

ELSE
DecPrice := 1;


Can Some one provide me a solution on this. Any Help will be appreciated.

matttrax

Mclaren wrote:

but Its executing the Else Part only.

So what does that tell you then? That the IF part of the statement is returning a FALSE, or XXXX.Qty is equal to zero. It's easy to check with the debugger.

jmagno

"XXXXX.SETRANGE("Qty",XXXXX."Qty");"

May be you need to double check the syntax of your code...

Savatage

perhaps qty is a flowfield? then you need to use calcfields, it's hard to tell with the information given.

also XXXXX.GET;

isn't getting anything unless it's some setup table
http://msdn.microsoft.com/en-us/library/dd338616.aspx