Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am using a table box and I want to add a calculated filed, Is there any way to do this, with out using chart ?
Thanks in Advance
Hi
Not in a table box as far as I am aware, but why not do this in a straight table?
Hi,
We can't add a calculated Field to the Table Box,but you can do the same in Straight table or Pivot table...
another thing is like u can create a field in the script part itself and use that field for Analysis ,i feel that will survive ur purposes.........
Regards,
Ajay
I am having the same problem, and was approaching it from the scripts angle. But I can't figure out how the script should be written. Any pointers?
Thank you,
Ian
I think I've figured it out, but not sure if it's the right approach.
In the script, I added another row under a table with the two data fields that I wanted to multiply
[Qty Received]*[USD Price]
This created a new box in the fields view. I right clicked on the title of the box, and selected Properties and gave it a Title
"Received Value"
Although this title took in the fields view, when I went to the Table view, the field was still named '[Qty Received]*[USD Price]'
Is there anyway I can name the new field within the new line in the script? I tried using '=[Receipt Value]' both before and after the calculation, but I get an error on the Reload.
Any ideas?
Thank you,
Ian
The syntax for renaming a field (or calculation) in the load script uses the "as" keyword
[Qty Received]*[USD Price] as "Received Value"
Hope this helps,
Andy
Thank you all.
That last syntax from andy was spot on.