Hello Everyone,
We need a formula that finds the percentage of the number of occurances of the text "early", "N/S", based upon the total number of records pulled.
We have these formulas(so far):
@CntDescriptions
IF ISNULL({CUSTOMER_ORDER_JOIN\.REAL_SHIP_DATE})
THEN "N/S"
else IF {CUSTOMER_ORDER_JOIN\.WANTED_DELIVERY_DATE}>{CUSTOMER_ORDER_JOIN\.REAL_SHIP_DATE}
THEN "EARLY"
@CntRecords - counts the number of records for the report based upon the product number field.
Count ({CUSTOMER_ORDER_JOIN\.WANTED_DELIVERY_DATE})
@CntEarly - counts the total number of occurances for the text "early". (Also have one for "N/S"
if ({@CntDescriptions}= "EARLY" )then 1
This works well to find the number of times the text = early is found.
Now, I also need to find the percentages of "early" and "N/S".
We've tried a few formulas, but nothing works. We sure hope someone can figure this one out.
Thanks for your help, in advance.
Lanie
laniet@ij.net
etroidl@conaxfl.com
We need a formula that finds the percentage of the number of occurances of the text "early", "N/S", based upon the total number of records pulled.
We have these formulas(so far):
@CntDescriptions
IF ISNULL({CUSTOMER_ORDER_JOIN\.REAL_SHIP_DATE})
THEN "N/S"
else IF {CUSTOMER_ORDER_JOIN\.WANTED_DELIVERY_DATE}>{CUSTOMER_ORDER_JOIN\.REAL_SHIP_DATE}
THEN "EARLY"
@CntRecords - counts the number of records for the report based upon the product number field.
Count ({CUSTOMER_ORDER_JOIN\.WANTED_DELIVERY_DATE})
@CntEarly - counts the total number of occurances for the text "early". (Also have one for "N/S"
if ({@CntDescriptions}= "EARLY" )then 1
This works well to find the number of times the text = early is found.
Now, I also need to find the percentages of "early" and "N/S".
We've tried a few formulas, but nothing works. We sure hope someone can figure this one out.
Thanks for your help, in advance.
Lanie
laniet@ij.net
etroidl@conaxfl.com