Forum Discussion

miltenburger's avatar
miltenburger
Helper V
8 years ago

Help with IF statement

Hi people,   I need some help with my if statement.  I need a new column based on following statements (see picture for three different columns right now)*    * "G" = Aantal geboekt <= Uren Geca...
Need Help
anandraman's avatar
anandraman
Helper I
8 years ago

TryTry this:

 

=IF( Aantal geboekt <= Uren Gecalculeerd ,"G",
IF(Aantal geboekt <= Uren Gecalculeerd + Uren Risico Opslag && Aantal geboekt > Uren Gecalculeerd + Uren Risico Opslag , "O",
IF(Aantal gebpekt > Uren Gecalculeerd + Uren Risico Opslag,"R")))

  • miltenburger's avatar
    miltenburger
    Helper V
    8 years ago

    Thanks anandraman

    I thought this was the solution, but it seems that there are still some wrong calculations in it

     

    • miltenburger's avatar
      miltenburger
      Helper V
      8 years ago

      In addition to this, to orange one doesn't seems te work

       

       

       

      • anandraman's avatar
        anandraman
        Helper I
        8 years ago

        Can you please share the PBIX file with this sample data ?