calculations in staraight tables

[#1]

Hi

Iwant to calculate some formula( each column /sum sqrt each table) on a staright tables but I could not find any solution for that

I attach screenshot

thanks

[PrashantSangle]

Hi,

Can you elaborate little more

Use Sqrt() to find square root and to calculate Total use

TOTAL keyword in your expression.

Regards

[#3]

Acutely I know the formula but I cant find a way for instance the calculation of column1

(195/(195^2+230^2+...)

[#4]

simply I dont know whats formula should be witten in defination in Expresstion tab

[anbu1984]

LOAD F1,

     article_use,

     Sqrt(article_use) As article_use_sqrt,

     book_use,

     soft_use,

     PHD_package,

     lang_package

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

In Expression,

=Sum(article_use) /Sum(Total article_use_sqrt)

[PrashantSangle · Accepted solution]

Hi,

Use expression like

     Sum(article_use)/Sum(Total sqrt(article_use))

Regards

[#7]

which definition show the first cell(195) in straight table?

[anbu1984]

Check this app