3 Replies Latest reply: May 26, 2015 8:42 PM by Ramon Covarrubias RSS

    Return value of a field based on value in another expression

    Richard Blakemore

      Hi

       

      I need to return the transaction type of the latest transaction as per below. That is, for a given stock item/customer/project etc. as defined in the cyclical dimension group, I can find the last transaction date using max(TransactionDate). What I need to do is to return what that transaction was e.g. Customer Order, Customer Invoice, Credit note etc.

       

      Any ideas?

      Last Activity Type.JPG