Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Just open the qvw file there u can see i am facing problem in getting sum.
Waiting for reply??????
Try this..
Sum({$<closingstock={">0"}>} Sale)
When you use the if-statements, you will often multiply you your rows when your conditinal sum depends on a value from another table.
This was not an issue up to version 8, but from 8.5 and onwards, it seems like the only thing that handle this correctly is "Set analysis"
/Martin
Try this..
Sum({$<closingstock={">0"}>} Sale)
When you use the if-statements, you will often multiply you your rows when your conditinal sum depends on a value from another table.
This was not an issue up to version 8, but from 8.5 and onwards, it seems like the only thing that handle this correctly is "Set analysis"
/Martin
Hi,
Thanks for reply. It's works fine .