Forum Discussion

blazko's avatar
blazko
Helper III
8 years ago
Solved

MIN, exlude blanks

Hi, I need to exlude BLANK's from a calculation, but cant't find the righ way. I want to create a calculated column to be exact, MIN from two other column, but when one of them is blank, the whole ca...
Need Help
  • Yggdrasill's avatar
    Yggdrasill
    8 years ago

    Well this is kinda silly but here goes

     

    Column =
IF (
    ISBLANK ( Table1[Column1] + Table1[Column2] );
    BLANK ();
    IF (
        ISBLANK ( Table1[Column1] );
        Table1[Column2];
        IF (
            ISBLANK ( Table1[Column2] );
            Table1[Column1];
            IF ( Table1[Column1] <= Table1[Column2]; Table1[Column1]; Table1[Column2] )
        )
    )
)

Yggdrasill's avatar
Yggdrasill
Responsive Resident
8 years ago

Well this is kinda silly but here goes

 

Column =
IF (
    ISBLANK ( Table1[Column1] + Table1[Column2] );
    BLANK ();
    IF (
        ISBLANK ( Table1[Column1] );
        Table1[Column2];
        IF (
            ISBLANK ( Table1[Column2] );
            Table1[Column1];
            IF ( Table1[Column1] <= Table1[Column2]; Table1[Column1]; Table1[Column2] )
        )
    )
)

  • karqueta's avatar
    karqueta
    New Member
    6 years ago

    Could you put an example with more than 2 columns?