divide column values not working in straight table? please help

[#1]

Hi,

when I am dividing column values in straight table it is showing blanks

I have below data in straight table

ID	name	source	months	date	sales	divide
52524546	xx	goods	60	14/04/2015	35634	-

dimensions: ID,name,source

expressions: months,date,sales,divide

I need divide column as calculated one as below

so, I have used divide = Column(3)/Column(1). this is not working.

how to get this correctly?

Thanks.

[sebastianlettner]

Hi,

as far as I know this should work like you described.

Can you upload an example .qvw?

[Digvijay_Singh]

See attached, but not sure the business case as aggregation logic cannot be understand from one row.

[sujeetsingh]

Try using expressions

[krishna20]

Hi,

Check whether the column no's are given correctly or not.

-> Try with Expression Label names to achieve division.

-> Try using direct expressions.

[#6]

Thanks. I tried this. not working. I have used in script as below

sales/months

this worked.

[sasiparupudi1]

may be you have a divide/0 issue? try if (column(1)>0,column(3)/Column(1),0)