Setting Currency showing no values

[priyarane]

Hi Community,

As attached, when I make selection Currency - USD then no value for some columns and If I clear then values are populating.

Note;

1. Only one Currency available - USD

2. Checked Data Model - its correct.

What is the error cause?

[#2]

Hi,

Try build one pivot table where dimension will be the Currency and use the same expressions of picture. Look if exists values for others currency or just is showing  '-'.

Godd Lucky!

[priyarane]

Hi Marcus,

As suggested I did it- now I got '-'. But I have to handle it in front end only like this '-' should change it to USD and If I select USD then all the values should appear. Can you please suggest

[#4]

After tell me what happened...

[priyarane]

My need as of now - If I select Currency - USD then all values should appear all inclue Null/'-' - is there any way like that

[#6 · Accepted solution]

You need to correct into script, this is the better way...When you load the table with the values, apply one "if", case currency is null, so replace for USD..If you want to send this part of script for I help you...

[ionut_toader]

Hi Pryia,

As I understand, there is a problem with your data sources. Use Marcos suggestion, add data source name (table name) to the pivot and this will probably show you that you don't have "Currency" field completed for all the data sources you are loading into the app.

Since you know all values are USD, I suggest you change your script in order to load "USD" in Currency field for those data sources that are missing the "USD" value. If the field "Currency" is not present in those data sources, add it in scripting.

Kind regards,

Ionut