6 Replies Latest reply on Oct 19, 2018 8:03 PM by Yuriy Fal

    Disagg Measure vs str(measure)

    Vincent Baumel

      I have 2 fields called Length and Width, and I'm trying to build a calculation that concatenates them with an 'x' in the middle like you might expect dimensions to be shown. The problem is that when I list out the disaggregated discrete values I see that wrapping them in a STR() function messes it up. I tested this out with Superstore data and found the same issue - I extended the formatting for Sales out to 10 decimal places and put it side by side with the STR() version:

       

       

       

       

      Does anyone know why this is happening? I'd rather not approach this solution by using a MID() or LEFT() function.

       

       

       

      -Vince