LimeSurvey version:6.4.0-23128
Own server 

==================
I tried doing some searching but just can't seem to figure this out.
It is possible to have a text array and have one column calculate the amount x .50 of the column just before it.
Like this:
Question Q006 Column SQX003 would equal SQX002 X .50
If so where would I even put that calculation. I tried using "{sum(this.SQX003*.50)}"  and also "self" but just couldn't get it to be a valid variable.
I also can't figure out where to put the question so that the column I want the answer in fill itself in.
Sorry to be kinda dumb on this. 
I'm using text array because the first column is not numeric. All the other are.
Thank guys. 

Well I figured out that this {sum(that.Q006.sq_SQX006.NAOK)} will total the columns. It doesn't quite get me where I wanted to be but it's close. Can I have it put that total in one of the Row/Columns. Say in an Empty row at the bottom of the ARRAY. That I can't figure out yet.

I still need help please!!! I figured out a lot of this but I'm trying to use an equation question to do a calculation(a percentage). Ho can I do that. I've been trying different things for hours with no real luck:
Q007_SQ001_SQX005=sum(that.Q007.sq_SQX002.NAOK)*(50/100)
{Q007_SQ001_SQX005=sum(that.Q007.sq_SQX002.NAOK)*(50/100)}
These comes back valid but do nothing. What am I doing wrong.
Iv've tried just doing
that.Q007.sq_SQX002.NAOK)*(50/100)
and
sum(that.Q007.sq_SQX002.NAOK)*(50/100)
etc.
Help please

You'd better sent a lss export of this question and maybe a sketch of what you try to do.

Joffm 

I’m not close to it now but it should be simple to explain. I want to sum a sub question column. (That’s not a problem) then multiple that by 50%. And put the result in a text or equation question (ie Total: $= the result)

Only this?

And put the result in a text or equation question (ie Total: $= the result)

Here in the help text of the question: {sum(self.sq_X003.NAOK)/2}

Or in a text display and all other questions: {sum(that.Q1.sq_X003.NAOK)/2}

 

Joffm

Wow! Thank you. I was sure I tried that. I must have had a typo because it works now.

Now I need to figure out how to display the result in $ format. Again, Iv'e gone searching but can't find it anywhere. Is it possible? EDIT: I should say I mean with 2 decimal points. So instead of showing 50 show $50.00

1. round((Q1,2)

2. round(100.0*Q1)/100

And why shouldn't you display
The amount is ${round((Q1,2)}

You can even prefill a cell in an equation like {Q2_y1_x3='$'+round((Q1,2)}

I did try that and it works if you have pennies but if you have say $50.00 it only shows $50 (no .00 pennies).
I saw there is number_format in the manual but it doesn't look like it allows for decimal placement either. I think I would need javascript to get what I want.
Thanks for helping.

In the manual you find the function "sprintf".
[url] www.limesurvey.org/manual/ExpressionScri...mplemented_functions [/url]





Joffm

@Joffm Thank you so much for your help. It's working perfectly.