Asta Powerproject Member for 18 years 5 months Member for 18 years 5 months Submitted by Chris Lothian on Mon, 2013-04-22 10:43 Permalink Thanks Chris.Keeping them Thanks Chris. Keeping them simple, and a lot of trial and error is the only way i can get a formula to work, so was hoping to avoid creating complex Formulae. If you're able to help, i've posted again with the details of the specific formula: http://www.planningplanet.com/forums/asta-powerproject/537833/formula-duration-between-tasks-based-code-library-allocation Thanks, Chris Member for 12 years 7 months Member for 12 years 7 months Submitted by Chris Ray on Fri, 2013-04-19 22:44 Permalink Hi Chris,if your not able to Hi Chris, if your not able to refer to other formulas, you will need to add the existing formula into the new formula e.g formula 1 - display long for all task over 10 days and short for less than 10 days if(duration > '10d', "Long","Short") formula 2 - depending on the result of Long or Short display different messages if(if(duration > '10d', "Long","Short")="Long","Task over 10 days","Task less than 10 days") I would always recommend that when building a new formula, build it in small sections so you know that each part works. Log in or register to post comments
Member for 18 years 5 months Member for 18 years 5 months Submitted by Chris Lothian on Mon, 2013-04-22 10:43 Permalink Thanks Chris.Keeping them Thanks Chris. Keeping them simple, and a lot of trial and error is the only way i can get a formula to work, so was hoping to avoid creating complex Formulae. If you're able to help, i've posted again with the details of the specific formula: http://www.planningplanet.com/forums/asta-powerproject/537833/formula-duration-between-tasks-based-code-library-allocation Thanks, Chris
Member for 12 years 7 months Member for 12 years 7 months Submitted by Chris Ray on Fri, 2013-04-19 22:44 Permalink Hi Chris,if your not able to Hi Chris, if your not able to refer to other formulas, you will need to add the existing formula into the new formula e.g formula 1 - display long for all task over 10 days and short for less than 10 days if(duration > '10d', "Long","Short") formula 2 - depending on the result of Long or Short display different messages if(if(duration > '10d', "Long","Short")="Long","Task over 10 days","Task less than 10 days") I would always recommend that when building a new formula, build it in small sections so you know that each part works.
Member for
18 years 5 monthsThanks Chris.Keeping them
Thanks Chris.
Keeping them simple, and a lot of trial and error is the only way i can get a formula to work, so was hoping to avoid creating complex Formulae. If you're able to help, i've posted again with the details of the specific formula:
http://www.planningplanet.com/forums/asta-powerproject/537833/formula-duration-between-tasks-based-code-library-allocation
Thanks,
Chris
Member for
12 years 7 monthsHi Chris,if your not able to
Hi Chris,
if your not able to refer to other formulas, you will need to add the existing formula into the new formula e.g
formula 1 - display long for all task over 10 days and short for less than 10 days
if(duration > '10d', "Long","Short")
formula 2 - depending on the result of Long or Short display different messages
if(if(duration > '10d', "Long","Short")="Long","Task over 10 days","Task less than 10 days")
I would always recommend that when building a new formula, build it in small sections so you know that each part works.