karie.kelly Posted June 22, 2017 Share Posted June 22, 2017 We have a cross tab report that displays various totals - it is two levels deep. However, when we export to excel, the totals are different. First - I notice those rows that had a blank/null value for the secondary subtotal are excluded form the export. But, that does not account for the difference in totals. Why is the export not exactly the same as what is on screen when exporting to any format - docx, xlsx, pdf? For example a distinct ID total in the UI shows 892, but all exports show totals = 693. And, when I try to add up different numbers, I cannot get to the 693 number. Link to comment Share on other sites More sharing options...
Friendly User Posted June 28, 2017 Share Posted June 28, 2017 What is the calculation function? Do you see the same problem (totals do not match) with different calculation functions? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now