Forum Discussion

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
8 years ago

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...
Need Help
Show and Tell
Tips and Tricks
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
8 years ago

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]

 

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
8 years ago

No tex, all value measures returns incorrect values. as G has incorrect volumes as well as turnover, FP1 and FP2