vovcha's avatar
vovcha
Frequent Visitor
8 years ago
Status:
Needs Info

Calculated columns incorrectly displayed in the data view in when filtered differently

I'm in a data view and am inspecting the data in 2 calculated columns.

If i filter the whole table to show me only 1 particular order (9437264) i see the correct (expected results) in the calculated columns. This is the data extract to excel:

However, if i remove the filter on the order and apply a filter on another column, then the data is incorrect. Oddly enough, i see the correct number for another order (9427759). 

Excel extract:

 

 

AFAIK, the calculated columns are not re-calculated on filtering in the data view. 

Thank you in advance.

2 Comments