13 Replies Latest reply on Mar 5, 2017 11:27 PM by koushik.neelakantha

    LOD function not getting applied in 'IF' statement

    koushik.neelakantha

      Hello everyone,

       

      I have a growth calculated field with Below Logic:

       

      Growth= {include [Account Name],[Buying Behaviour],[Speciality],[ Procedure Name],[PRODUCT_SAP_CODE]:AVG([Growth Potential])}

       

      when I drag Speciality & Growth and check for 'EP' field i am getting proper Values. But with Below IF Condition i am not getting exact Value.

       

      Growth IF=if   [Speciality] = ' (EP)' then

      [Growth]

       

      Query:

       

      What is the difference between taking speciality in Filter & displaying Growth Values & creating calculated field with speciality =EP and displaying Growth Value?

       

       

      Please help me out.

       

      Regards,

      Koushik.