locked
Xpath Calculation to Count Column's Value RRS feed

  • Question

  • Dear All,

    I aim to count the number of occurrences of a value in the column using Sharepoint Designer 2007 dataview webpart. I am applying the formula:count($nodeset/@ColumnA). All I am getting is number of every row in that node. I also tried various other expressions available on this forum but not getting the desired result.

    What would be the best suitable expression? I look forward to hear from you guys.

     

    Tuesday, May 17, 2011 12:02 PM

All replies

  • Please try these

    count(/dsQueryResponse/Rows/Row[contains(@ColumnA,’Value’)])

    count(/dsQueryResponse/Rows/Row[normalize-space(@ColumnA)='Value'])"


    --Cheers
    Friday, June 10, 2011 10:02 AM
  • Hi Prasath,

    I tried applying the provided formulas but not getting the desired result. Please consider the fact that I am taking some of each node/group here.

    Thanks,

    FSJ 

    Wednesday, June 15, 2011 6:29 AM