Skip to content
ProjectControls.com
Asta Powerproject

Formula in Asta - Slip

In the Open Standard
Paul WoodleyMember for 9 years 11 months
Created
1
1
0

Column to show "0"

-If the task is in the past AND 100% complete
-If the task is in the future and 0% complete

Columns to show result from the following formula;
(DateDiff(Start, Today)-[~LP].ActualDuration)
IF
It is in progress and being progressed.


If the task is in the past with 0% progress it should be showing a value. The difference between today and the start of the task (latest progress)

 


I hope that gives an indication and enough detail as to the requirements.

I am in a bit of a pickle. Hoping someone could shove me in the right direction.
 
I need the following (regarding slip)
 
Column value to show "0" IF;
 
- The task is in the past AND 100% complete
- The task is in the future and 0% complete
 
Column value  to show result from the following formula (the bit I could get to work);
DateDiff(Start,Today)-[~LP].ActualDuration
IF
- The task is in progress
 
 
IF the task is in the past with 0% progress it should be showing a value - the difference between today and the start of the task (latest progress)
 
 
 
I hope that gives the detail explicitly enough and hope someone can help out! I am tearing my hair out over this....
Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi PaulWhy go to such

    Hi Paul

    Why go to such bother.

    Set your reschedule window to block out completed tasks.

    Or show the Percent complete Nr 0% to 100% and that will show the data you want. 

    Best regards

    Mike Testro.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?