on 01-16-2013 6:31 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Aakash,
so did you add the currency infoobject of that particular keyfigure to the drill down? Did you turn on the result properties of that object? Do you now see sub totals after every currency block like INR, USD? What exactly happens in your currency block subtotals?
Regards,
Arunan C
Hi Arunan,
Let me explain what i did here
I have added the Ocurrency field in the Row block.
I have restricted the 0Amount with value type, currency type and i put it in the Column block.
Then for 0currency in setting-->Display__>Results row changed to Always display from always suppress.
Result block is showing as
for 1st few INR getting sum value the it is not considering next USD again INR values repeating like this happening with other currencies
Please suggest sorry if im troubling you guys
hmm, you should have seen a subtotal immediately after the INR block. Did you check the currency dimension of your amount keyfigure? Is it 0currency? In your above example, the currency field in the rows should have INR corresponding to your INR amounts and $ across your USD amounts etc. Is this fine? And is the 0currency added as last infoobject in your row?
Hi Aakash,
In bex query designer click on key figure go to aggregation tab in that u have option of exception aggregation and below in the drill down u have to select characteristic for which u want to define exception aggregation. select currency
Then
first define formula as NODIM for key figure.
Add currency characteristic in your drill down
Regards,
Saurabh Singh
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
Hi Aakash,
I am not sure , but try once exception aggregation on the basic of currency characteristic .
Regards,
Saurabh Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If it is not possible i need overall result of all the currencies is this possible?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.