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

    LOD function not getting applied in 'IF' statement


      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





      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.