Currently, I am experiencing huge duplicate records in the Story reports when creating it for performance form templates to Capture the Section Rating - Objective/Competency and Overall rating.
Is the duplication due to 'Other Ratings' returning more than one User ID? If this is the case you could create a calculated column that checks this (IF formula) and add a query filter to exclude one of the IF statements.
Hi Gloria. I also encounter the same problem with duplicate records in query. It not affects my calculated results in story but heavily slow down my report. I wait forever for it to load. Can I also send you my query to get your advice on how to remove the uneccessary duplicates?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.