Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
How can i do a sum of total X / sum of total Y
example show in excel pivot table
Your expression seems right, is it not doing what it is supposed to?
Hi Sunny,
i got "-"
pls see the screen shot.
=sum((Total X)/(Total Y))
Or try ur single expression in text box
=sum(Total X)
=sum(Total Y)
Please share sample data to understand the issue. Thanks.
Hi,
check values for field CT,PM_WAIT_TIME_Q and CNTR_N In list box.
did you get values for these 3 fields????
Regards
hi all,
Pls see the attached file.
Can you share the application by any chance?
Hi Sunny,
I have attached the qvw file.
Or you can look at my excel file, it is what i trying to do for the yellow box.
hi chk below...ur sum(CNTR_N) values is '0' so its nt gettng correct.
PFA