Formula not calculating properly
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23031
Printed Date: 29 Apr 2024 at 1:59am
Topic: Formula not calculating properly
Posted By: th3strikes
Subject: Formula not calculating properly
Date Posted: 06 Jan 2023 at 6:55am
If this formula = 2
if({V_LMINVTRY_MANUFACTURED.CUSTOMER} Like '*Customer*') and(((3600/{STANDARD.CYCLETM})*{PARTNO.STDCAV})*3) >={V_LMINVTRY_MANUFACTURED.QUANTITY} then
((3600/{STANDARD.CYCLETM} *{PARTNO.STDCAV})/({V_LMINVTRY_MANUFACTURED.QUANTITY}))*3
else if(((3600/{STANDARD.CYCLETM})*{PARTNO.STDCAV})*3) >={V_LMINVTRY_MANUFACTURED.QUANTITY}
then((3600/{STANDARD.CYCLETM} *{PARTNO.STDCAV})/({V_LMINVTRY_MANUFACTURED.QUANTITY}))*3
else 2
Inserting +2 = 4
if({V_LMINVTRY_MANUFACTURED.CUSTOMER} Like '*Customer*') and(((3600/{STANDARD.CYCLETM})*{PARTNO.STDCAV})*3) >={V_LMINVTRY_MANUFACTURED.QUANTITY} then
((3600/{STANDARD.CYCLETM} *{PARTNO.STDCAV})/({V_LMINVTRY_MANUFACTURED.QUANTITY}))*3+2
else if(((3600/{STANDARD.CYCLETM})*{PARTNO.STDCAV})*3) >={V_LMINVTRY_MANUFACTURED.QUANTITY}
then((3600/{STANDARD.CYCLETM} *{PARTNO.STDCAV})/({V_LMINVTRY_MANUFACTURED.QUANTITY}))*3
else 2
Why does inserting *2 = 3 when it should be 4?
if({V_LMINVTRY_MANUFACTURED.CUSTOMER} Like '*Customer*') and(((3600/{STANDARD.CYCLETM})*{PARTNO.STDCAV})*3) >={V_LMINVTRY_MANUFACTURED.QUANTITY} then
((3600/{STANDARD.CYCLETM} *{PARTNO.STDCAV})/({V_LMINVTRY_MANUFACTURED.QUANTITY}))*3*2
else if(((3600/{STANDARD.CYCLETM})*{PARTNO.STDCAV})*3) >={V_LMINVTRY_MANUFACTURED.QUANTITY}
then((3600/{STANDARD.CYCLETM} *{PARTNO.STDCAV})/({V_LMINVTRY_MANUFACTURED.QUANTITY}))*3
else 2
|
Replies:
Posted By: hilfy
Date Posted: 01 Feb 2023 at 9:49am
Why not use *6 instead of *3*2?
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|