Same app giving different calc results on different PCs...same version of QV

[pgdavis2]

I have an app that uses the following formula to show the number of days the Demand PL is positive.

count(if(aggr(sum(DemandPL),Year,Month,Day,Pnode)>0,TotalLMP_DA))

It is very strange...on my laptop the formula gives correct results. but on another PC using the same QV9 SR6, it give an incorrect result with excatly the same settings and selections.

It also happens when I save it in QV10 and open in QV10 on the other PC.

Anyone ever seen this behavior before?

[llauses243]

Hi Paul,

Pls to revise attach & compare ...

Good luck, Luis.

[pgdavis2]

Thanks for the suggestion but it did not correct the problem.

[pgdavis2]

I've looked at it now on 4 different PCs...2 get the aggr correct and 2 have it wrong. All 4 PCs are 64 bit. Changing the SR does not correct the issue.

It must either be a system setting like the date format that was suggested, or CPU related.

[pgdavis2 · Accepted solution]

I was able to clean up the data somewhat and the issue went away. Go figure.

Still, it's strange how QV handled "garbage" data differently across machines, but at least it plays nice with well constructed data! That's what matters.