Forum Discussion
Error Expressions that yield variant data-type cannot be used to define calculated columns
Hello Communties, I am getting below error message, Error Message:”Expressions that yield variant data-type cannot be used to define calculated columns”,In below formula [AMERICAS AO] and [AMERICAS...
thank you so much Hotchill,that's the requirments.May be i can change it with 00000.Thanks
HotChilli
Community Champion
Community ChampionI don't think there is a workaround. You need to decide what data type the calculated column has and then find acceptable values to go in there. It's either going to be text or numeric, it can't be both at the same time.
thank you so much Hotchill,that's the requirments.May be i can change it with 00000.Thanks