Skip to Content
0
Former Member
Jan 03, 2012 at 07:34 PM

Calculation of Total weight with formula

14 Views

Dear experts,

Case:

All these fields are in repetitive area

UoM Qty Weight ExpectedOutput

K -


100-- 20 --


2,000,000

-


20-- -15 --


300

k--


40 -5 --


200,000

Condition:

-If UoM is NOT equal to K then

Qty x Weight

-If UoM is equal to K then

Qty x Weight x 1000

How can this be achieved in Crystal Reports using formula?

Please advise.

Thank you in advance.

Regards,

Sanil