Announcement

Collapse
No announcement yet.

Compare Currency fields

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Compare Currency fields

    Hi, I have several currency fields on an opportunity and want to ensure that they are all the same. Rather than do this at run time (where things are not always enforced) I want to have a daily report that lists the ones that are issues, and then fix them.

    So on my filter for the report I want to compare 2 fields e.g.:
    Code:
    amountCurrency != supportCurrency

    I can compare a field to a constant, but I don't seem to be able to compare 2 fields in the report. Can you advise please?

    Thanks.

  • #2
    hello,
    Report does not support comparing fields, but only if you create other field for this
    There is an entity having 2 float fields, A & B how can i set the filter of the report to show record which value of field A is greater than that of field B?

    Comment


    • #3
      Ok, thanks. I am on the hosted solution so don't have access to the files.

      I will use it as the basis for a solution then; I will create a new, read only field called something like "CurrencyMatches" and update that using a formula on every right. My report can then search for that field being TRUE or FALSE.

      Thanks for the help, really appreciated.

      Comment

      Working...
      X