Can someone help me convert them to SSRS e pression numberVar SumOfQty := sum({VW_RPT_SERVICEDISCOUNT.QTYORLENGTH},{VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME}); numberVar SumOfTotalBasePrice := Sum({VW_RPT_SERVICEDISCOUNT.TOTALBASEPRICE}, {VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME}); if SumOfQty <> 0 then (SumOfTotalBasePrice / SumOfQty) else SumOfTotalBasePrice if sum({VW_RPT_SERVICEDISCOUNT.QTYORLENGTH},{VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME}) <> 0 and not isnull(sum({VW_RPT_SERVICEDISCOUNT.QTYORLENGTH},{VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME})) then (Sum({@TotalNetPrice}, {VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME}) / sum({VW_RPT_SERVICEDISCOUNT.QTYORLENGTH},{VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME})) else Sum({@TotalNetPrice}, {VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME}) ) FM

Hey Farhan, Are both the Crystal Expressions you have listed above part of the same formula? Also, what does the @TotalNetPrice correspond to? Assuming they are part of two different formulae, the first one in SSRS goes like this: IIF ( Sum (Fields!QTYORLENGTH.Value, "UOMSHORTNAME") <> 0, Sum (Fields!TOTALBASEPRICE.Value, "UOMSHORTNAME") / Sum (Fields!QTYORLENGTH.Value, "UOMSHORTNAME"), Sum (Fields!TOTALBASEPRICE.Value, "UOMSHORTNAME") ) The above would be assuming you have a group on the UOMSHORTNAME field. For the second part of your formula above, I am unsure of @TotalNetPrice and hence will be able to help when you clarify the same. Please Note: I have replaced the "VW_RPT_SERVICEDISCOUNT" by "Fields!" as it is in SSRS. HTHPlease mark correct answers :)

Hi IceQB, @Totalnetprice is another formula that become a part of the epxression. Both expression are used in separate text boxes so they have individual functionality.And your right bout the Grouping on OUMSHORTNAME. @Totalnetprice = =sum(iif (parameters!ExcludeRebill.value=0 or isnothing(Fields!TOTALREBILL.Value),Fields!TOTALNETPRICE.Value, Fields!TOTALNETPRICE.Value-Fields!TOTALREBILL.Value)) FM