Forum Discussion

opticshrew's avatar
opticshrew
Resolver II
9 years ago
Solved

Showing blank values as zero when the data doesn't exist

Hi all,   I have a table that contains a list of items with there associated values:   The issue I am having is that because the values for Sol and Oth are blank they are not being sorted b...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi opticshrew,

    Based on my understanding, althrough the Line and Order columns come from different tables. There must have a relationship between them, right? Otherwise, we are unable to create a table like your given.

    You can create a calculated column in the table where the "Line" field locates using the formula.

    New Order=IF(ISBLANK(RELATED(Table2[Order])),0,RELATED(Table2[Order]))


    Then you can create create your table based on the new calculated column.

    If this is what you want, please share more details for further analysis.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi opticshrew,

Based on my understanding, althrough the Line and Order columns come from different tables. There must have a relationship between them, right? Otherwise, we are unable to create a table like your given.

You can create a calculated column in the table where the "Line" field locates using the formula.

New Order=IF(ISBLANK(RELATED(Table2[Order])),0,RELATED(Table2[Order]))


Then you can create create your table based on the new calculated column.

If this is what you want, please share more details for further analysis.

Best Regards,
Angelia