How to replace with message instead of dashes in total?

[#1]

Hi,

I have straight table

with Dimension : Member

       Expression1: Count(Distinct(Reference_SheetA))

       Expression2: =Replace(count({<Result1={'Fail'}>}Distinct Reference_SheetA),'0', 'No Data')

       Expression3: Expression1 + Expression2

so, i expression2 if there is no data it is showing 'No Data' . because of this expression3 is showing dashes. How can I replace the dashes with 'No Data' if there is no data after suming expression1 and expression2?

Thanks.

[#2]

On the Properties tab of the straight table, change the Null symbol to No Data

[MK_QSL]

Try

RangeSum(Expression1,Expression2)

[its_anandrjs]

Hi,

You can do some change in Expression2 like

if( count({<Result1={'Fail'}>}Distinct Reference_SheetA) = 0,'No Data',count({<Result1={'Fail'}>}Distinct Reference_SheetA))

Thanks & Regards

[#5]

Thanks. it is showing 100%. but I need 'No Data'

sorry i entered wrog expression3 actually in the expression3 actually it is Expression2/Expression1

is it possible now

[#6]

Thanks. But I need only for expression3. I don't want to replace in all columns if any case there is no data.

[#7]

Thanks. Still showing same dashes.

[jerem1234]

Maybe try something like:

alt(Expression2/Expression1, 'No Data')

Hope this helps!

[MK_QSL]

Try Like Below....

=IF(ISNUM(Column(2)/Column(1),Column(2)/Column(1),'NO DATA')

[antoniotiman]

If(Column(2)='No Data','No Data',Column(2)/Column(1))