- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add 2 partcular values in field-straight table
Hi All
I have some issue in straight table. i got below table in QV
But user wants like below one:
4 field values we need add this table
1) non land Total= Debenture+Guarantee+others 2) non os overall= Debenture+Guarantee+others+land
3) non os land Total= OS Debenture+OS Guarantee+OS others 4) non os overall=OS Debenture+OS Guarantee+OS others+OS land
in sales expression avg of field values
count expression add of field count
so please help on this issue. kindly check attachment of QVW and EXcel. !
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
any one can help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How are you getting non land total of 76.6? 90+90+50 = 230... Are you calculating the avg? 230/3?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes i calculated AVG Bro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Bro..its working fine..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
Please share the methods or expression u used to achieve this...