/Currency Value Calculation |tableau Community Forums

Currency Value Calculation |tableau Community Forums

Is this correct?

1.png

 

Here are the calculated fields for reference:

 

1. Latest Transaction for Customer: {FIXED [Customer ID]:MAX([Transacntion ID])}

 

2. Current Balance (Quantity): {FIXED [Customer ID]:MAX(IF [Transacntion ID]=[Latest Transaction for Customer] THEN [Coin Balance (Quantity)] END)}

 

3. Current Rate: {FIXED [Customer ID]:MAX(IF [Transacntion ID]=[Latest Transaction for Customer] THEN [Market Rate] END)}

 

4. Current Balance: [Current Balance (Quantity)]*[Current Rate]

 

Hope this helps. 2019.2 Workbook attached for reference.

Original Source