2 Replies Latest reply on Oct 24, 2012 10:36 AM by Samuli S.

    How to return highest/lowest value in a group of accounts?

    Samuli S.
      Hi gurus,

      I'm facing a requirement where in HFM, I need to set the value of an account to be the same as the highest value of a group of other accounts (POV is the same, all accounts are lowest level in hierarchy).

      So basically, I need a rule/script/function that enables me to say: "look up the values of account 1, account 2 and account 3 for this point of view, and set the value of account 4 to be whatever is the highest of the values of accounts 1, 2 and 3".

      I would be extremely grateful for any insights and assistance. I'm sure this is possible in VBScript....