Forum Discussion
SELECTCOLUMNS does not return correct values from existing table
Hello, I have an existing table called OK_INVOICE_ALL_EXCEL. so i have created new table called PARETO to make more lean table. To create PARETO table i used below formula PARETO = SELECT...
Hi tex628
Not all columns returns incosistent figures but especially some entities and some products returns incosistent figures
For instance G entity returns -7099 tons whereas it should be -3825
Under that entity, all products returns incosistent values
| Entitiy | Volume (ton) OK_INVOICE_EXCEL | Volume (ton) PARETO |
| A | 11.124 | 11.824 |
| B | 4.893 | 4.893 |
| C | 1.600 | 1.600 |
| D | 24 | 24 |
| E | 87 | 87 |
| F | 47 | 47 |
| G | -3.825 | -7.099 |
| Grand Total | 13.950 | 13.950 |
From what i can tell your "PARETO" table is a combination of columns from the OK_INVOICE_ALL_EXCEL table and four different measures. Is it only the measure values that display incorrect values?
"volume (ton)";[Volume (ton)]; "Turnover";[TurnoverPV]; "FP1";[FP1]; "FP2";[FP2]
No tex, all value measures returns incorrect values. as G has incorrect volumes as well as turnover, FP1 and FP2