Forum Discussion
Calculated column IF always returns FALSE
I have the following calculated column, and for some reason it will always return to the FALSE expression (i.e. it always uses the RateToDollar): TransactionAmountConverted = CALCULATE(VALUES(Tra...
Part of my data modelSample data
The original transaction amounts can be in any currency available in the Currency table. Based on the user's choice of report filter (currently either USD or EUR), the Transaction Amount should display the transaction's converted amount. So for example, if the user selects 'EUR' in the report filter, the Transaction Amount column should display all original transaction amounts converted to euros. Similarly, if the user would select dollar, for dollars.
Oh, and the CurrencyFormat was created for the sole reason to act as a report filter.
Could it be that a calculated column cannot handle dynamicly set values from a report filter? Would you know anything about this?