Expressions that yield variant data-type cannot be used to define calculated columns

[Anonymous]

Helllo all,

I am having a familiar issue with my expression, but unfortunately i can't find the several solutions between the serveral posts.

I become the message:

Expressions that yield variant data-type cannot be used to define calculated columns. 

Spoiler

I think this one is pretty simple,

When the columm "LD Meldtijd" = "Nee"(NO), then this columm shows me nothing.

Other wise this column needs me to show the Time from tblDataInput[Laad Order Tot] minus tblDataInput[LD Meldtijd duur]

Can you tell me what is the wright formula for this?

Thank you,

[Anonymous]

Hello Greg,

Thank you for the fast response.

This works!

But what is teh sense of this?

Is "" only for text and BLANK() for calculations?

[Greg_Deckler · Accepted solution]

@Anonymous Use BLANK() instead of ""