Formulae errors pleaes help

[Former Member]

Hi

I have a formulae which is defined as below :

Formu = ( Price1 x Weight 1 ) / weight 2

Now because prices has Values in Dollar and Weight has values in Lb and Pound.

In the result it appears as

$6789.0456 Lb

Both $ and Lb appears in Result Output.

Can any one please advise how to resolve this..

How to stop this display with $ and Lb.

If i have to chose the Display of Either values how to do that

If i want to display just $ how to do that ?

If i want to display just Lb how to do that ?

If i want to display Neither $ nor Lb how to do that ?

Pleaes help

[Former Member]

Hi

To display $

Formu = {Price1 * NODIM( Weight 1 )} / NODIM (weight 2)

To display LB

Formu = {NODIM(Price1) x Weight 1}/ weight 2

Not to display anything....you can refer previous post

Regards

N Ganesh

[Former Member]

You can use NODIM function to supress the Units.

Create Formulae - >NODIM ( KEYFIGURE or Calculation )