Skip to content
ProjectControls.com
Asta Powerproject

BI Export - working days and elapsed duration

In the Open Standard
Dariusz CMember for 7 years 10 months
Created
4
3
0

Hi

In my model I extract tasks data according to line below from model file:

<Column name="DurationDays" datatype="Duration" group="Date" formula="Duration / '1d'"/>

 

The problem is that some tasks have duration in working days and some of them in elapsed days, please look at attached screenshot for more details.
Working days are not a problem at all. Problem is with elapsed duration


What should I do to get durations in format I have in Powerproject into the same table?

 

Thank you in advance for any hint!

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi Dariusz - welcome to

    Hi Dariusz - welcome to planning planet.

    Right click the duration table - select Format Cells - Left click Duration - select your format "Day".

    Best regards

    Mike T.

    Report
  2. 0
    Dariusz C ·
    #2

    Hi MikeThanks for reply and

    Hi Mike

    Thanks for reply and warm welcome ;)

    It's not about Asta Powerproject itself but BI Controller.

    These elapsed durations you could see in screenshot are OK, my entire plan contains days and elapsed days.

    The problem is coming when I want to export Powerproject data to external datasource.

     

    For example I've got 2 tasks:

    Task 1   , 2d duration

    Task 2, 2ed duration

    Model files has formula for duration and it "force" to write durations in days:

    formula="Duration / '1d'"

    But for Task 2 it will return incorrect value becasue of elapsed units...

     

    With formula:

    formula="Duration / '1ed'"

    it will return correct values for durations expressed in elapsed days (Task 2), but not for working days (Task 1).

    Still with me? :)

    I can't find any way to export correct durations via BI Controller regardless of duration units used for tasks.

     

     

    Report
  3. 0
    Ben Taunt ·
    #3

    Hi Dariusz, There are

     

    Hi Dariusz,

     

    There are several potential solutions to this.  The simplest is to add a column that tells you if a task is a Working or Elapsed:

     

    <Column name="ElapsedStatus" datatype="Boolean" group="Date" formula="IsElapsedTime(duration)" />  

     

    Cheers,

     

    Ben @ Powerproject 

    Report
  4. 0
    Dariusz C ·
    #4

    Hi Ben Thanks for that. This

    Hi Ben

     

    Thanks for that. This is exactly what I did:

     

    <Column name="DurationDays" datatype="Duration" group="Date" formula="If(IsElapsedTime(duration) = TRUE, Duration / '1ed', Duration / '1d')"/>

    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?