1 Reply Latest reply on Feb 27, 2017 1:54 PM by Jim Dehner

    How can I get a calculated column from a formulated variable?

    Kyle Bruno

      I am trying to create two calculated columns, one for total count and one that's a percentage of the total lines based on that total count.

      I am needing to count a formulated variable that I created which is this:

             [Tag] =If([Shp not Inv]=2 And [Less than today]=1 And [Held Code]<>"T1") Then "1"

      ultimately, it provides a 1 on lines of the orders that meet these three criteria. I can change it to be =If([Shp not Inv]=2 And [Less than today]=1 And [Held Code]<>"T1") Then 1, which makes it a Numeric Measure, or by leaving it as it is, it stays a String Measure, either way, when I try to count the rows with a 1 applied to them I get the #MULTIVALUE error.

      I have tried several different formulas, such as:

                =Count([Order Number]) Where([Shp not Inv]=2 And [Less than today]=1 And [Held                  Code]<>"T1")

              &

                =Count ([Order Number];Distinct) Where ([Tag] = "1";[Tag])

              &

                =Count([Tag])

      Any advice?