Problems Suppressing Zero Values

[dg3249]

I believe that one of my formuals is causing my results to show a zero value for the first group record, but the next group records show the correct value.
I have copied my formula below. I have also tried to suppress zero values and this does not seem to work for me.
Any Suggestions??

FORMULA***
If {@Mon} in {vw_rpt_Weekly_hires.start_date} to {vw_rpt_Weekly_hires.finish_date}
then {vw_rpt_Weekly_hires.order_id} else
If {@Tue} in {vw_rpt_Weekly_hires.start_date} to {vw_rpt_Weekly_hires.finish_date}
then {vw_rpt_Weekly_hires.order_id} else
If {@Wed} in {vw_rpt_Weekly_hires.start_date} to {vw_rpt_Weekly_hires.finish_date}
then {vw_rpt_Weekly_hires.order_id} else
If {@Thu} in {vw_rpt_Weekly_hires.start_date} to {vw_rpt_Weekly_hires.finish_date}
then {vw_rpt_Weekly_hires.order_id} else
If {@Fri} in {vw_rpt_Weekly_hires.start_date} to {vw_rpt_Weekly_hires.finish_date}
then {vw_rpt_Weekly_hires.order_id} else
If {@Sat} in {vw_rpt_Weekly_hires.start_date} to {vw_rpt_Weekly_hires.finish_date}
then {vw_rpt_Weekly_hires.order_id} else
If {@Sun} in {vw_rpt_Weekly_hires.start_date} to {vw_rpt_Weekly_hires.finish_date}
then {vw_rpt_Weekly_hires.order_id}

 

[synapsevampire]

An example of @mon, etc., would be useful.

But I'd guess that this error results because none of the conditions exist, try adding a final else which is just else
-9999999

If it display the -9999999, then you know that your if's aren't catching all of the conditions.

If you don't get the -9999999, then you probably have an order_id of 0

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dg3249]

I tried what you suggested, and it does print out -99999 when I make an additional IF statement.

The @Mon formula is "{?PromptDate} + 1 "

What I am doing is prompting for a date which then displays which people are working under a specific order for a specific week.
I though that I had captured all that I needed in the previous formula. Do you have any ideas as to what I may be missing?