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