I needed to do a check between rollup helper and Salesforce Native Rollups. To get around a few problems I had to use the following algorithm to convert Salesforce Date/Times to Excel Dates and Times:
B1 = SUBSTITUTE(SUBSTITUTE(A1,"T"," "),".000Z","")
C1 = DATEVALUE(B1) + TIMEVALUE(B1)
I first exported the two record types from Salesforce using Workbench.
I grouped the two sheets into one.
I added columns on all date times using the above algorithm.
I then ran pivot tables on the data.
No comments:
Post a Comment