Forum Discussion

nanutum's avatar
nanutum
Icon for Helper I rankHelper I
9 years ago

Condition if in table power pivot problem

 

i used Power pivot and want to add condition if in table then relationship table have problem


Problem in RED ZONE

 

when i used condition if table have problem

 

sorry about my english

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    9 years ago

    Hi nanutum,

     

    The question is that in power pivot the blanks is not equal to 0 you need to do something like this

     

    if (
     [%ACH] = "",
     0,
        if ([%ACH] >= "1,
            5000,
            0
            )
  )

    Regards,

    MFelix

    • nanutum's avatar
      nanutum
      Icon for Helper I rankHelper I
      9 years ago

      hi MFelix

       

      My Problem is 4,5,6 in "B" when i used condition if 4,5,6 show in "A" Why ?

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        9 years ago

        Hi nanutum,

         

        Can you post a sample of your data and the final result you want to achieve?

         

        Regards,

        MFelix