Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Looking for a formula Newbie question

Hallo everybody,

 

Im looking for a formula when the Column Facturatie compleet says Nee. it will make the cell blank in column afwijking t.ov. raming(%).

  • I assume you've got a measure that's working out the current output where it's not Nee right now, so you want something like:

     

    newmeasure = if([facturatiecolumn]="Nee",blank(),[existingmeasure])

4 Replies

  • jthomson's avatar
    jthomson
    Icon for Solution Sage rankSolution Sage

    I assume you've got a measure that's working out the current output where it's not Nee right now, so you want something like:

     

    newmeasure = if([facturatiecolumn]="Nee",blank(),[existingmeasure])

    • Anonymous's avatar
      Anonymous
      Not applicable

      sorry for not being precise.

       

      the output should be if Ja then do nothing. (show the value in afwijking...)

       

      thx for your reply by the way

      • McCow's avatar
        McCow
        Icon for Resolver III rankResolver III

        You should create new measure (or new calculated column) with condition, like above ( jthomson).

         

        Best regards