Hi, can anyone please help me. I have just noticed that when i export my data into excel it sums up to a different total to my QlikView reports. The problem appears to be that the data in Qlikview is to 3 decimal places but when I export it into excel it rounds up to the nearest integer. Settings on both reports are set to money formatted to £ and no decimal places. Any idea how i resolve this as i can't see any settings to change other than the display format of money?
Yep Richard, It was all around the formatting. Stupidly because I had formatted the cells to zero decimal places it exports at zero decimal places and then because you have lost the roundings then it gives you a different total. As such I changed the format to 5dp and it was fine. However, report looks stupid in QV now. Must be a quirk of the system. Frustrating
