Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one account number which has 3 currencies (AUD, NZD and USD), the numbers are converted in AUD.
In my straight table, the currency column showing blank, because it has three currencies..
the only possible option i have is the account number belongs to country "Australia".
I want to show the currency "AUD" instead of blank.
Any idea to bring in this output.
May be some set analysis also will help.
somthing like this
=only({<Country = {$(=max(Country))}>}Currency)
Cheers
Ren
you could add another table to the data model for looking up Country to Currency:
load
Country,
Currency as Default_Curreny
..
that's linked via the country field in you Account Data.
Than you could simply use Default_Currency to be shown.
BR,
Christian
Hi,
Create Inline Table and Mention Currency and CountryName in that,
Try something like this,
LOAD * INLINE [
Country,Currency
Australia,AUD
];
Regards
Hi
Its not possible to use a set expression like that. The set expression is evaluated once for the whole chart, and not on a row-by-row basis.
I suggest that you post a sample of your model, so that people can make informed suggestions, rather than guessing.
HTH
Jonathan