2 Replies Latest reply: Dec 11, 2014 8:43 AM by Serhan Celebi RSS

    Calculated dimensions in script not loading in table box

      Hi all,

       

      I'm currently working on a piece and it requires a  few calculated dimensions.

       

      I've added them into my script

       

      LOAD

           Field1

           Field2

           Field3

           Field4

           Field5

       

           //calculations

           [Field1]/[field2] as [Calculated1],

           [Field3]/[Field1] as [Calculated2],

           ([Field4]+[Field5])/[Field2] as [Calculated3]

      FROM

      aaa.xls

       

      The issue I'm having is if I display them in my table box, the table becomes greyed out and has a big X in the middle. All other data is fine. I can do this in a straight table but I'm displaying a lot of dimensions so it doesn't look nice without the horizontal scrollbar.

       

      Any suggestions on this?