Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I 'm not getting the result as expected.Can anyone help me on this.
Result should be Sum(A)/Sum(B) and Clomun1 <> 0
Could you please provide a little more context? Maybe a more detailed description or a sample qvw?
if(Cloumn1<>'0',Sum(A)/Sum(B))
sum({<Column1 -= {0}>}A)/sum({<Column1 -= {0}>}B)
This will give you sum of A divided by sum of B where column1 does not equal 0