Report + Table + IF IsNull([Output_Data]) THEN "None" ELSE [Output_Data] ENDIF

Question

Hi All,

Need your expertise !!

I'm trying to create a body of email with a condition: If output is blank or empty the body of email should show a term "None" or If Output has data the return the actual value (table).

Using formula tool tried with below formula but is not giving correct result.

IF IsNull([Table]) OR Trim([Table]) = "" THEN "None" ELSE [Table] ENDIF

So in short my requirement is in Layout i.e. "Body of Email" should show as NONE. example below

Hi Team,

Please find below summary of the volume for today's VD trades.

Below trades are >=50mm for today's VD.

NONE

Request you to provide best approach.

For your reference have attached workflow and input file.

Reporting Email.yxmd

Reporting Input 05172026.xls

Thank you in advance !!

OTrieger · Answer

@bubblyjai1982

A table is kind of an element so you can not just replace it with None, you need to have another element with the same name, like the text editor.

So put a filter tool, one connect to the table tool the other to the text editor tool, make sure that both named Table, you can change the name with Select tool, union the data and now you will have in the Table field data in a table or None.