Forum Discussion

eduardoa's avatar
eduardoa
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Managing a wrong total result in a visual

Hello, In the table, we have multiple currencies with corresponding rates. The total result should simply be the multiplication of [Amount] * [LastRate]. While the total displayed in Excel is corr...
  • Rupak_bi's avatar
    Rupak_bi
    1 year ago

    Hi Here is your result

    Hope images are self explainatory. 

     

eduardoa's avatar
eduardoa
Icon for Advocate I rankAdvocate I
1 year ago

Hello Rupak_bi ,

 

Thanks so much. Will try and let you know. 

eduardoa's avatar
eduardoa
Icon for Advocate I rankAdvocate I
1 year ago

Hello Rupak_bi 
Unfortunately, it didn’t work.
The calculated column returned no values

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    1 year ago

    Hi Here is your result

    Hope images are self explainatory. 

     

    • eduardoa's avatar
      eduardoa
      Icon for Advocate I rankAdvocate I
      1 year ago

      Thanks so much Rupak_bi 

      Cheers!