INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...One of the best run forums I have used in years! ...I like the way the site is organized and your no tolerance of flames..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Web Development > Information Builders, Inc.: WebFOCUS Forum

help for building subtotals with different fields

Read More Threads Like This One

karibai (Programmer)

27 Apr 06 8:21

Hi All,
i shall write a report, which has the following design.
I need subtotals after field 2 for field 4 and field 2. If You don't understand my (bad) english, please, look at the following example:

Field 1    Field 2    Field 3    Field 4    Count    5 days    10 days
SO    B    FKA    1    5141    47,50%    66,70%
        FKA    2    6372    40,70%    58,10%
        PKA    1    69391    51,40%    77,50%
        PKA    2    30308    41,60%    64,70%
        VTA    1    704    28,70%    43,30%
        VTA    2    2130    32,40%    48,80%
----------------------------------------------------------
    B        1    75236    51,00%    76,40%
    B        2    38810    40,90%    62,80%
----------------------------------------------------------
    B            114046    47,50%    71,80%
==========================================================
    etc.    ...
                ....
----------------------------------------------------------
SO            1    189986    28,60%    43,20%
            2     40940     1,70%     2,50%
----------------------------------------------------------
                230926    23,90%    36,00%
----------------------------------------------------------
SW    F    FKA    1    7107    47,00%    67,20%
        FKA    2    10504    41,30%    59,70%
        PKA    1    38749    75,10%    88,70%
        PKA    2    26349    61,10%    77,70%
        VTA    1    701    40,10%    62,50%
        VTA    2    1216    39,90%    67,00%
    F        1    46557    70,20%    85,00%
    F        2    38069    54,90%    72,40%
    F            84626    63,40%    79,40%

    etc
            TOTAL    xxx    xxx    xxx

Is there any possibility, to realize this report in this way?

Thanx
Karin

bcbasslet (Programmer)

18 May 06 20:50

yes, using FML (the Financial Modelling Language component of Focus..it's part of the core product)
You seem to want to subtotal B for FKA=1 and then again for FKA=2, and then again for all FKA of that B.
Subtotal isn't the right word, you want RECOMPUTE's because of the percentages.
this kind of thing is perfect for FML. Just read about it in you manuals and you'l love it.
sometimes its called EML (for extended matrix language)
It basically pulls your final report data into a matrix, and then lets you operate on that matrix with Excel-like commands,(row and col references) all in the same fex. way cool.

-SUSANNAH

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Information Builders, Inc.: WebFOCUS