Any formula gurus?

Hi Craig

I have just had a look at the formula creation system in Library and you are right it is a nightmare.

I just tried to add 21 days to the end date of a task to replicate an approval period - couldn't do it.

Maybe ASTA can simplify it in v 12.

Meanwhile if we have a 21 day approval period I will stick to adding a bar.

Maybe Mr Willard can pick up the thread or Tekin can tell us.

Best regards

Mike Testro

Hi Mike

To do formula for what you want just add a formula

finish+'3w'

When you the add a column with the field for your new formula you will get this date against every activity - not sure how to filter to only specific activities

Regards

Peter G

Hi Richard,

Is it possible to compare two taskcodes from two different librairies? The two librairies are identical. Librairy A represents the actual status and librairy B represents the wanted status at the last day of the year. When the codes are the same a priority is low, otherwise high. Is it possible to make a formula in PP to avoid exporting my report to Excel? 

This formula does work but does not give the expected result;

if(TaskCodeLibrary(1174, 0, na) = TaskCodeLibrary(1223, 0, na), low, high)

Probably the result of expression TaskCodeLibrary(1174, 0, na) is not the represented name (na?) in a column.

1174 is the id of the Library. What is the meaning of the number "0" and "na" and what are the possible values? What is the result of this code?

Regards

Jan Berg

Hi Jan,

This works for me. Just replace your code library ID's

If(Text(Task.TaskCodeLibrary(9686, 0, na)) = text(Task.TaskCodeLibrary(9687, 0, na)), Low, High)

Regards

Andrew

Hi Andrew

How are we poor mortals supposed to know that?

In the next upgrade can we have a simplified formula entry dialogue - something on the lines of the revised filter system.

One more thought - how about a thread on Powerproject upgrade wish list?

Best regards

Mike T.

Hi Mike,

Yes I guess Richard alluded to that in his comment before.

I have created a mini training manual that takes you through the basics and principals of formulas. If you would like a copy please email me.

Once you have grasped the basics the rest is easier although the more complex thye get the more you need to remember algebra from school!

I guess the complexity is a trade off against functionality. Try doing what we can offer in some of our competitors!

Thanks

Andrew

Hi Andrew,

This works for me too. Thanks.

I suppose Asta has made a manual with de formulae. Why does Asta not publish such a manual? Now it is to much trail and error. 

Regards,

Jan

Hi Jan,

I ahve sent you the manual

Regards

Andrew

Hi Andrew

Why not add it as an Asta web download?

Best regards

Mike T.

Andrew

I agree with Mike, is it not possible to add the manual to asta 'Knowledge base' ?

Regards

Derek

Hi All,

This will be posted today to the knowlege base

Regards

Andrew

Andrew

Where could this be found within 'Knowledgebase' ?

Regards

Derek

Andrew

Where could this be found within 'Knowledgebase' ?

Regards

Derek

Hi Derek,

You can search on "formulas" and look for an article titles "Working with formulas", or you can use the "go to article number" on the bottom of the search box to go straight to it (article number 1634).

Regards

Andrew