BI Export - working days and elapsed duration

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')"/>

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.