4 Replies Latest reply: Feb 22, 2015 8:50 PM by Yilin Xie RSS

    Data misaligned after inclusion of Calculated Dimenion

      I have been trying to get the straight table working.

       

      In the qvw file I have included a sheet("Without Comments (Correct)") that contains the correct values for the various fields and another sheet ("With Comments (Erroneous)"), which after adding in the calculated dimension, the values somehow appears incorrect.

       

      Calculated Dimension: =if(Topic=Remark,Comments)

       

      The idea was that if the value from "Topic" and "Remark" matches, i would want to extract the corresponding "Comment" for that "Remark".

       

      I have included the tables (data source) and the qvw file used for this analysis.

       

      Thanks for the help.