Forum Discussion

Fahad5's avatar
Fahad5
Frequent Visitor
4 years ago
Solved

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

Hi all,   Please help below function is getting error,   Please help me.   Partition-1 = IF(ISBLANK(TOKENFLEX_COUNT[Partition_1]),FORMAT(TODAY()-1,"yyyymmdd"),TOKENFLEX_COUNT[Partition_1])
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You'll get this error if the result-if-true and the result-if-false arguments of IF return different data types, for example, text when true and a number when false.

     

    If you want to return text in the case of a blank, then you need to also return text when it's not blank too. You could use FORMAT there as well. For example,

    Partition-1 =
VAR Partition = TOKENFLEX_COUNT[Partition_1]
RETURN
    IF (
        ISBLANK ( Partition ),
        FORMAT ( TODAY () - 1, "yyyymmdd" ),
        FORMAT ( Partition, "Standard" )
    )
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Fahad5 

 

Try this:

Partition-1 =
IF(
    ISBLANK( [Partition_1] ),
    FORMAT( TODAY() - 1, "yyyymmdd" ),
    [Partition_1]
)

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/