5 Replies Latest reply: Aug 27, 2015 1:02 PM by Sinan Ozdemir RSS

    Custom Measure Help - Assigning Rebate % In Sense

      Good Afternoon Everyone,

       

      As a distribution company our bottom line is effected by the amount of rebates that we receive from our supplier. These rebates are a direct result of over all sales for the current fiscal year. 

       

      What I would like to build is a measure that would illustrate the impact that our customers have against those rebates. here is the catch, all the rebate values are not equal so I need to build some sort of "IF" statement that would calculate the impact of potential rebate generation based on the specific sales of that vendor in correlation to that customer.

       

      In my measurement I would need to capture sales specific to this fiscal year. The formula that I am using for that is " ({$<FISYR = {$(=year(Today()))}, " and the field that my vendors are in is " SUPPLR" and the field that contains Total sales is "SASALES"

       

      so what I would need to create is something like this... the problem I am having is when the Account has purchases against many Vendors not just a single vendor and I have to calculate the total impact across many vendors at once.

       

      IF ({$<FISYR = {$(=year(Today()))}, SUPPLR = 'BAYWES' THEN SUM (SASALES * .10),

      IF ({$<FISYR = {$(=year(Today()))}, SUPPLR = 'ECM' THEN SUM (SASALES * .05),

       

      Thank you for your help...

       

      Barry