Home currency not available in custom columns

  • 1
  • Question
  • Updated 8 months ago
  • Acknowledged
Hi there,

I'm trying to create a custom column in a report in Replicon Web Timesheet: Project and Billing Edition.

Our organisation's base currency is Euro but I'm creating a report in Australian dollars.

The base report I'm working from is the Project status report. The two columns that I need (Cost Amount and Task Estimated cost) are available by default as column options. When I run report with those two columns selected, it returns the correct values in the correct currency (AUD).

I want to create a custom column that returns the remaining budgeted cost by subtracting the cost amount from the task estimated cost.

I can do this in base currency (TaskBaseEstimatedCost - BaseCostAmount) to get a result in euros.

However, when I use the field names for the home currency I get an error saying the field name is not valid.

I've tried using the column names that appear in against the checkboxes in default report (without spaces or brackets etc) and also using the column names that appear in the generated report. These do not work.

Are these columns simply not available for use in custom columns or do they have different field names?

Thanks,

Tim

Photo of Jordan, Tim

Jordan, Tim

  • 3 Posts
  • 0 Reply Likes

Posted 8 months ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1657 Posts
  • 114 Reply Likes
Hi Tim,

We use Base currency to display the home currency. We don't have columns with "home currency" names. Aren't the columns with base currency providing you the details?