Simple Script Problem

[AH]

Hi,

I have different Currency Code in my dashboard. In one tab I showed all the currency code and in another tab i showed only two currency code across the tab using filter in the script like this : if(DataAreaID ='TT','USD','GBP') as FunctionalCurrency.

Now i was trying to show only USD as the reporting currency in another tab. What should i do in the script? I used action to select only USD for that tab and its working but when i switch to other tab the USD currency selection persists which i dont want. I would like to do that from the script.

Any suggestions?

Thanks,

Shan

[Anonymous]

Use trigger to reset the reported currency on leaving the sheet

[djsampat]

View image and do the following:-

Open Sheet Properties, Select Triggers tab, On ActivateSheet, click Add Actions, Click Add, select the Action "Clear Field" (or "Clear All" if required) and in the Field, select the Field, click Ok twice and go back to the Main tab, make a few selections and then click the new Sheet1 and it will clear the selection.

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

[Anonymous]

Hi,

In the script define

if(DataAreaID ='TT','USD') as FunctionalCurrencyUSD,

if(DataAreaID <>'TT','GBP') as FunctionalCurrencyGBP

now you can use separate columns for you calculation or selection.

[AH]

Hi Chandal,

Thanks for your reply. But this script is not working :if(DataAreaID ='TT','USD') as FunctionalCurrencyUSD.

This script is working:  if(DataAreaID ='TT','USD','GBP') as FunctionalCurrency.

But the second one : if(DataAreaID ='TT','USD') as FunctionalCurrencyUSD. is not working. Dont know why.

Thanks,

Shan

[Anonymous]

use this :

if(DataAreaID ='TT','USD',' ' ) as FunctionalCurrencyUSD,

[alkesh_sharma]

Use Clear All trigger on moving to other tabs and selection of USD currency, trigger, on moving to that particular tab

Probably the simplest way to address your issue.

[AH]

Hi Chandel,

I used this and its working

if(CurrencyCode ='USD',CurrencyCode) as ReportingCurrency,

Thanks for your feedback.

Thanks,

Shan

[AH]

I also tried this solution. It worked.

Thanks a lot.

Shan

[djsampat · Accepted solution]

Please mark correct Answer, so the Question status can be closed.

Thanks. Glad to have been of assistance.