Split of month-values into workingday-values

[reinholdgraf]

Hi.

I need to split our plan-sales (bases on months) into workingdays.

Theoretically, I have to split each Month-Plansales into the individual working-days of that month.

Likely thru a Loop / AutoGenerate.

For the formula, I thought about:

Plan-WorkingdaySales = Plan-MonthSales / (networkdays (monthstart(Date),monthend(Date))

Unfortunately, I have no clue how to set-up the Loop.

Regards,

Reinhold

[reinholdgraf]

unknown error ---

we have 3 different Loads in one Section.

How is the order for the system to process these Loads ?

[sunny_talwar]

Not sure I understand your question, do you mind elaborating?

[reinholdgraf]

top-down or bottom-up ?

I need to understand, how the systems processes your script-example to find the error.

(your script-example with inline-data works fine).

I first create a tmp_file containing all divisions with all plan-sales (monthly).

With this file (resident), I want to use your script to create daily-plansales and further calculations (e.g. currency-conversions, etc.)

[swuehl]

You are using preceding loads in your script, these are executed bottom to top.

Preceding Load

What is the table source of your LOAD statement labelled with tmp_Umsatz_Plan?

Sunny was using an INLINE table, what table source do you intend to load? the Excel file?

Then remove the Concatenate LOAD prefix, it should be used only on the topmost LOAD statement.

If you need to use multiple files, create a concatenated table before, then use a resident table to use Sunny's script snippet.

[reinholdgraf]

OK.

That's what I did.

1. Create a concatenated table (tmp_UMSATZ_PLAN1) from various excel-files

2. Use this table in the snippet

I removed now the "Concatenate", but with the same error-message when loading the data

How shall I find an "unknown error" ???

[reinholdgraf]

Solved now !

problem was within the EXISTS-Formula.

Very helpful issues discussed here:

• Snippet from Sunny and Exists-Formula
• Info about Preceding Loads / Loading multiple files by Stefan

Many Thanks to both !