@battk I need your help. I have two column with the same name. How can i grab the value differently.

var transactionSearchObj = search.create({
      type: "transaction",
      filters: [
        ["type", "anyof", "CashSale", "CustCred", "CustInvc", "CashRfnd"],
        "AND",
        ["subsidiary", "anyof", subsidiary],
        "AND",
        salesChannelArray,
      ],
      columns: [
        search.createColumn({
          name: "item",
          summary: "GROUP",
          label: "Item",
        }),
        search.createColumn({
          name: "formulacurrency",
          summary: "SUM",
          formula:
            "(case when ( {trandate} BETWEEN TO_DATE('" +
            r1StartDate +
            "','mm/dd/yyyy') AND  TO_DATE('" +
            r1EndDate +
            "','mm/dd/yyyy')  ) then {netamount} else 0 end)",
          label: "R1Net",
        }),
        search.createColumn({
          name: "formulanumeric",
          summary: "SUM",
          formula:
            "(case when ( {trandate} BETWEEN TO_DATE('" +
            r1StartDate +
            "','mm/dd/yyyy') AND  TO_DATE('" +
            r1EndDate +
            "','mm/dd/yyyy')  ) then {quantity} else 0 end)",
          label: "R1QtySold",
        }),
        search.createColumn({
          name: "formulacurrency",
          summary: "SUM",
          formula:
            "(case when ( {trandate} BETWEEN TO_DATE('" +
            r2StartDate +
            "','mm/dd/yyyy') AND  TO_DATE('" +
            r2EndDate +
            "','mm/dd/yyyy')  ) then {netamount} else 0 end)",
          label: "R2Net",
        }),
        search.createColumn({
          name: "formulanumeric",
          summary: "SUM",
          formula:
            "(case when ( {trandate} BETWEEN TO_DATE('" +
            r2StartDate +
            "','mm/dd/yyyy') AND  TO_DATE('" +
            r2EndDate +
            "','mm/dd/yyyy')  ) then {quantity} else 0 end)",
          label: "R2QtySold",
        }),
      ],
    });

You can see that I have two column with same name, is there a way for me to grab the second “formulanumeric” I tried

result.getValue({
        name: "formulacurrency",
        summary: "SUM",
        label: "R1Net",
      });

same answer as last time

Oh,,,,

at a certain point, it just becomes easier to store the column you create in a variable

Ok i’ll use

result.columns[i]

then

you can choose your own function name

Got it, thank you