Hiding Partial Sum

[rohitians]

Hello,

I have inventory report where in i have quantity ,rate and Value..

The Dimensions are Product Name  and Vendor Name....

Here when showing Sub total i want to hide the sub total for Rate and only show sub total for Quantity and Value..

How can i do that what would be code n where do i need to write..

I am attaching the sample report format..

Thanks and Regards,

Rohit

[#2]

Hi,

You can use like below,

IF(RowNo()=0 or IsNull(RowNo()),'',Sum(Rate))

Karthik

[#3]

when showing Sub total

you want to hide the sub total for Rate and only show sub total for Quantity and Value..

then

take a straight table--

dimension1-- Product Name

dimension2-- Vendor Name

Expression1-- sum(PurchaseQty)

Expression2--PurchaseRate

Expression3-- sum(POValue)

see sample attached file.

[rohitians]

Hello Karthik,

Thanks

But where do I write this code..

Explain  and  want to show total quantity and Value and I want to hide the rate  coulmn's total whose code is

if (SUM({$<DocumentType_Code={1}/*,OS_Purch_Qty={">0"}*/>}PurchaseLine_Qty)>0,AVG(Purchaseline_UnitCost),0).

Thanks and Regards,

Rohit

[#5 · Accepted solution]

Write "Rate" column expression like below,

IF(RowNo()=0 or IsNull(RowNo()),'',if (SUM({$<DocumentType_Code={1}/*,OS_Purch_Qty={">0"}*/>}PurchaseLine_Qty)>0,AVG(Purchaseline_UnitCost),0))

Logic behind above expression is, RowNo() function will reply 0 if that row is subtotal and RowNo() function will reply empty value if row is GrandTotal. So for Rate column we are forcely giving "Null" value in Subtotal and Grand Total.

[#6]

Hey Vishwaranjan,

hw u did tht, viewed ur application bt didn understand????

[er_mohit]

For purchase rate write this expression

If(Dimensionality()=2,sum(PurchaseRate))

hope it helps you

[rohitians]

Thanks,

Everyone for Helping,

Karthik Mohit Vishwaranjan..