Skip to Content
author's profile photo Former Member
Former Member

Issue with the overall result at reporting level

Hi Friends,

I have an issue with one report.

My issue is in the Column field for calculating transaction currency im using one Key figure with few restrictions.

Issue is here im getting different currency values for Examp

1000 INR

200INR

100 USD

500 JPY

10JPY

200 EUR

200 RON

________

*

________

like this we are getting values in the result.

At the summation level it is not calculating the total. I'm getting stat(*) symbol at the result column.

My requirement is need to calculate the result as individual currency fields like from the above values

Report output should be

1000 INR

200 INR

_________________

Result= 1200 INR

__________________

100 USD

___________________

Result= 100 USD

____________________

500 JPY

10 JPY

____________________

Result=510JPY

_____________________

etc.

Can anyone suggest me how could i achieve this one. Its urgent

Many thanks in advance

Regards

Aakash G

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 16, 2013 at 06:47 AM

    Hi,

    Use Nodim function---make a new fromula and add your keyfigure inside it NODIM (KF).

    This function is available under data functions.

    In case you need to display result currecny wise then workaround can be to restrict kF currency wise and dsiplay the same.So you need to make different columns for it.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Akash,

      Can you confirm ... one thing.....

      have u deactivated all other objects "suppress results only" and on 0 currency field show it as " dipaly results will deff word with respective its currency ex; INR,USD,EURO, here it will first show all EURO data and its result and on.....

      Regards,

      Padugula

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2013 at 06:36 AM

    If it is not possible i need overall result of all the currencies is this possible?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2013 at 06:39 AM

    Hi Aakash,

    I am not sure , but try once exception aggregation on the basic of currency characteristic .

    Regards,

    Saurabh Singh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.