How to calculate from entries to entries in Sharepoint - InfoPath Dev
in

InfoPath Dev

How to calculate from entries to entries in Sharepoint

Last post 08-28-2018 08:17 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-23-2018 03:44 AM

    How to calculate from entries to entries in Sharepoint

    Hi All, Am creating the each tasks as a entries in share point List(Using infopath), A column of a all task contains Passed or fail. Now i wanna calculate and display(Anywhere in share point) as Total number of Passed task/Total number of tasks. 1.Is it possible ?? 2.Possible to export the entries to a online excel in same share point folder ,calculate this formula in excel and display in same share point as a web part from excel in share-point ?? Suggest me a solution. Thanks in advance guys :-)
  • 08-28-2018 08:17 AM In reply to

    Re: How to calculate from entries to entries in Sharepoint

    You could do this in an InfoPath form displayed as a webpart, I'd guess? You could just query the list - use a count formula with a filter to count just the passed tasks, and count w/out a filter to get the total.... See the attached sample. I'm using main data source fields, but you could add a data connection to your list and do something similar. Save the file locally, right click and select preview and you can try it out.
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.