BigdaddyPrecision
Technical User
Hey everyone,
First off I am relatively new to Crystal Reporting and have taken classes and been part time active in it for the past 1.5 years. I don't have an IT background and have decided to learn this system to support my employees and my customers better. Just so you have a medium level understanding in my formula writing expertise.
I am looking to have my SAP crystal report perform a formula where it is subtracting a specific number of days from a field if criteria is met accordingly. What I need help with is how do I skip specific days of the week because we do not schedule Friday, Saturday, or Sunday. What I am trying to accomplish is when the formula is run and returns the output/answer that will not land on a friday, saturday, or sunday.
Here is the current formula that does the math correctly but does not take into consideration these weekend days I am trying to avoid.
Thank you in advance for your help & consideration.
Formula:
if {Job_Operation.WC_Vendor} = ["MTLRECV", "HORIZONTAL"]
THEN
{Job_Operation.Sched_Start}-4
First off I am relatively new to Crystal Reporting and have taken classes and been part time active in it for the past 1.5 years. I don't have an IT background and have decided to learn this system to support my employees and my customers better. Just so you have a medium level understanding in my formula writing expertise.
I am looking to have my SAP crystal report perform a formula where it is subtracting a specific number of days from a field if criteria is met accordingly. What I need help with is how do I skip specific days of the week because we do not schedule Friday, Saturday, or Sunday. What I am trying to accomplish is when the formula is run and returns the output/answer that will not land on a friday, saturday, or sunday.
Here is the current formula that does the math correctly but does not take into consideration these weekend days I am trying to avoid.
Thank you in advance for your help & consideration.
Formula:
if {Job_Operation.WC_Vendor} = ["MTLRECV", "HORIZONTAL"]
THEN
{Job_Operation.Sched_Start}-4