show null as blank

[surajap123]

Hi All,

In the dataset(excel) you can see all products has no data for 'Third'(column in straight table) and Product-C also has no data for Second & Third. So i expect to show blanks in the straight table cells.

My basic formula is see the pecentage when i do- budget/sales.

In the straight table i want to represent expression output as below--

If no data in sales and budget--show black

If data in sales and budget--show the respective percentage.

My below exprssion is not working to handle nulls.

if(sum(Budget_First) = 0,0,

if(len(sum(Budget_First))=0,' ',

   sum(Sales_First)/sum(Budget_First)*100))

Please help!

[MK_QSL · Accepted solution]

Something like this?

IF(IsNull(SUM(Sales_First)/SUM(Budget_First)),Null(),SUM(Sales_First)/SUM(Budget_First))

use Second and Third respectively.

[YoussefBelloum]

Hi,

take a look at the background color of the expressions

PFA

[jyothish8807]

try this:

if(sum(Budget_Third) =0,'',

if(len(sum(Budget_Third)) =0,' ',

   sum(Sales_Third)/sum(Budget_Third)*100))

br,
KC

[surajap123]

Thanks everyone