Hello,

I have a problem in the FST-Module.

My report consists of 3 columns.
First column is current data,
second is budget data,
third is deviation of current data to budget data, in an excel-sheet the formula would be (current-budget)/budget .

Additionaly when the current is less than budget then the deviation should be shown with a negative sign.

First I tried "Percentage over columns" with budget as 100% column but then I get deviation calculated as current/budget, not (current-budget)/budget.

When I use "amount/quantity" with the formula (current-budget)/budget, the deviation is correct calculated for all positions with sublevel zero but not for the summarized positions. There the system is also just summarized which leads to errors.

Please give me any idea you have.
Thanks,
Juli


:confused:

Hello Juli,

Which session does your report run from ?

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

hi,

the selection of the values is done by tffst1205m000 and the printing by tffst1450m000 .

Regards, Juli

Just an obvious suggestion.

I had very similar problem with tfgld3405m000 in relation to budgets so it would certainly be worth looking at the latest version of the session.

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

Hi,

it is not a bug. We have the latest objects for FST-Module on the server installed.
The question was just which formula solve the problem.

In fact, I solved it. Now we have an additional "help" column which is not printed but used for calculation.

First the absolute deviation is calculation between actual and budget, and then the standard functionality Percentage over columns is used.
And ...
it gives the correct figures.

Regards, Juli