How to get column in table box

[#1]

Hi,

I have a table box and I need to show values for Dividend columns which will have data from three tables.

Table1 amount

Table 2 Commission

Table 3 Grosssalary

I need to show Dividend as (Amount+Dividend)/Grosssalary. Is there any way to get this in table box? could anyone let me know please and I have join between three tables.

Thanks.

[tresesco]

Use straight table.

[#3]

When I am using straight table it is showing Out Of Object memory that's the reason I changed to Table box. Any help please.

[tresesco]

Turning to table box would not be the solution (because, in table box, you can't have any calculated col/expression ). I guess there is something wrong in your modelling. Check if there is any IMproper JOIN or too many synthetic keys in the data model.

[#5]

Thanks and I don't have any synthetic keys in Data model and atleast if I use table box it is showing data. earlier staright table worked fine but since yesterday I was facing the problem. is this any odd issue?

[CELAMBARASAN]

tresesco sugesstion will work.

if it says Out of object memory, then first the join between

Table1, Table 2 and Table 3

[CELAMBARASAN]

Could you please post the image of your data model and table box?

[#8]

Please find attched.

[Josh_Good]

Try filter the data down to a very small amount of data.  If you still get the out of memory error than it is either a data model issue or an expression issue.   If you do not get the error then it is likely your machine is under resourced for the amount of data you are dealing with.