Level 3 Sprint 2 : Assign > 1?

jehular
jehular
in Academy Discussions
'SYS06 Territory Account Details'.Count[SUM: Account Name] 
jehular_0-1666596611391.png

 


Can someone help me understand what am I missing here?

Thanks 
Tagged:

Comments

  • ChrisAHeathcote
    ChrisAHeathcote

    @jehular 

    Can you confirm the formatting of the line item used in the SUM as I suspect it is a text format. 

     

    Try pulling through the CODE of the list and use this in your SUM instead. 

  • jehular
    jehular

    will try doing that, it was a list formatted format

    Thank you 
    jehular_0-1666602864264.png

    jehular_1-1666602893694.png

     

  • jehular
    jehular

    @ChrisAHeathcote 

    I did try different approach on how to get assigned>1? 

    • Assigned>1?: Is the account assigned to more than one territory?
       I did use formula for assigned >1 - cf_Account > 1
      what did I do wrong it should checked on the assigned lineitem candyose but it did not 
      jehular_1-1666748370477.png

       

       

     

  • sdavidko@ciena.com
    sdavidko@ciena.com

    Can you elaborate on how you got Assigned > 1? I tired this but nothing gets checked

    image.png

Categories