4 Replies Latest reply on Aug 29, 2018 6:06 AM by John Croft

    Combining a STR with Calculated Field Turning into Count Function

    Nicolas Martin

      Good morning,

       

      Straight to the point:

      My table of data is below. I need to concatenate a calculated Field and a Text Field. it looks like this:

      STR(INT([Current Annual Category Cost]-[Adjusted Annual Category Cost]))+' '+[Product Category]. This output turns into a (Count) function.

       

       

      When I try to use the [Savings Category] + [Product Category] it says they are Agg and Non-Agg.

       

      More Reliant Data below:

       

       

       

      PS, I'm not looking to do it my way, I'm just looking for a way to get it done. I hope to have data that will look like:

       

      Burn Supply - $8,748.65

       

      Thanks Again