Forum Discussion

nickspizza's avatar
nickspizza
Helper I
4 years ago

dataflow error convert decimal into type logical

My Dataflow cannot refresh. It gives me an error:     Error: Expression.Error: We cannot convert the value 0.29032258064516131 to type Logical. Value = 0.29032258064516131. RootActivityId = e257f7c...
Dataflow
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

nickspizza Do you have a custom column anywhere doing some sort of calculation?

  • nickspizza's avatar
    nickspizza
    Helper I
    4 years ago

    Greg_Deckler  Yes I do. They look like this:

     

    Table.AddColumn(#"Added Custom4", "LTE Hybrid TGT", each if [Product] = "TM LTE Hybrid" and [Agent]=[Store] then [TGT] else if [Product] = "TM LTE Hybrid Renewal" and [Agent]=[Store] then [TGT] else if [Product] = "TBM LTE Hybrid" and [Agent]=[Store] then [TGT] else if [Product] = "TBM LTE Hybrid Renewal" and [Agent]=[Store] then [TGT] else null)
    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      4 years ago

      Hi nickspizza ,

       

      I can not reproduct your problem, could you please share your dataflow model.json or sample data?

       

       

       

      Best Regards,
      Winniz