Skip to Content
avatar image
Former Member

Reporting format Issue .. Result row Count Display...URGENT!!!!

Hello All,

Need solution for my issue in reporting,

This is my Report format

Date A/c number Kf1 Kf2 Kf3

01.06.07 123 10 20 0

234 20 30 30

456 50 0 25

789 0 25 0

Result 80 75 55

01.07.07 124 10 0 10

134 30 30 30

457 40 0 0

788 0 25 10

Result 80 55 50

Now my requirement is to display Count in the result row as

Date A/c number Kf1 Kf2 Kf3

01.06.07 123 10 20 0

234 20 30 30

456 50 0 25

789 0 25 0

Result 3 3 2

01.07.07 124 10 0 10

134 30 30 30

457 40 0 0

788 0 25 10

Result 3 2 3

and to be more precise this is my requirement

Date Kf1 Kf2 Kf3

01.06.07 3 3 2

01.07.07 3 2 3

I made key figure Calculate Result as Count <> 0 and Calculate single value as Supress Result for each key Figure and A/c Number No display I got result like this showing all data as blank, however the rows will exist.

Date Kf1 Kf2 Kf3

01.06.07

3 3 2

01.07.07

3 2 3

But I need my result should be like this

Date Kf1 Kf2 Kf3

01.06.07 3 3 2

01.07.07 3 2 3

How can I Acheive this either by work Book Or by Query ,

Please help me

Thanks for all ur support in advance

Sai.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 09, 2007 at 05:00 AM

    hi Sai

    Using formula variable with replacement path could be the solution to your report issue.

    1 Create a New Calculated Key Figure

    2 Create a formula variable for getting the account count.

    3 Maintain description and variable name use processing type as replacement path.

    4 Select the characteristic account n°.

    5 In Replace Variable With select Attribute Value.

    6 For Attribute menu select Characteristic Reference (Constant 1).

    7 Then place your newly create variable * by 1

    8 Maintain the description of your calculated KF press ok

    9 Then in the properties of your calculated KF maintain the time of calculation as After Aggregation.

    Use the calculated KF in your query this should work properly.

    Hope this could help you

    regards

    Boujema

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      sometimes if you add something like this it forces the count to occur at the level that you want:

      1) Create a new formula variable based on Account Number ZF_ACNU

      2) create a calculated key figure (not a formula) for the count and including this at the end

      • NODIVO (ZF_ACNU/ZF_ACNU)

      This trick often fools BeX into performing the count at the proper level.

  • avatar image
    Former Member
    Oct 08, 2007 at 02:49 PM

    Hi Sai,

    Just change the Calculate single value as "Count All Values <> 0"

    tick the Cumulated (check this option, you may req or you maynot).

    If it work please assign point.

    Regards

    Mahendra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2007 at 05:09 AM

    Hi Sai,

    Just Right Click on your Key Figure and from Context menu Select -->

    Calculate >Result as > Count All values <> 0, or you can use Counting All Values option for general other cases.

    This will display results as Rowcount of number of rows.

    Hope this helps

    CK

    Add comment
    10|10000 characters needed characters exceeded