1 Reply Latest reply on May 31, 2013 1:27 PM by Shawn Wallwork

    calculation data on row level:

    Juwel Aktaruzzaman

      calculation data on row level: I am trying to create a calculated field on a row level. e.g. I have 5 clients whos accounts are in different currencies. GBP, EUR, JPY. I have 12 months of data. I need to calculate all these months balance into USD. I have another file that shows monthly rate to USD for each of these currencies. Create a new column with all the balance per client per month in USD? I do not want it aggregate as I can do this. Can someone help?