Hi there
Does anyone know of a way to change a total currency in a view column programatically?
I have a column of budget items which can be in pounds, dollars or euros. It’s fine just to show the items themselves with an @if in the column formula to display a different currency symbol, but the total currency will never change. It doensn’t look very good with just a plain number total and currency details.
This is purely client-based, any suggestions appreciated.
Cheers
Dan
Subject: Different currencies in view column
Are you totaling different currencies in one column? What would the total value represent if that is the case? I would recommend creating a separate column that represents the value in a single currency like USD or Euros and total that column. You can then set this single currency column to have a Number Format of Currency and set the Currency symbol for all rows including the total row.
Subject: RE: Different currencies in view column
Hi, thanks for your response.
No, the column would only ever have one currency, each document would have it’s currency set and it would always be the same.
Having said that, it’s also an embedded view, so in fact different categories would have different currencies, so I think I’m not going to be able to do what I want.
Maybe I need three different columns for the different currencies, hiding the column depending on the currency in the documents.
Don’t know if this is possible with embedded views though either. Any ideas?
Cheers
Dan
Subject: RE: Different currencies in view column
To get the currency symbol on the total line, my only other suggestion would be different views, but that adds overhead.
Subject: RE: Different currencies in view column
Thanks Tim, I think we will do that. Creating a different view for each currency, and displaying the view dependant on the currency, which is in the main form, seems like the way to go.
Dan