Hi I written below expressions =Round(Sum(Fields!Average_Days_from_Flooring_to_Title_in_Vault.Value, "YTD") / CountRows("YTD"), 0) =Round(Sum(Fields!Average_Days_from_Title_at_Auction_to_Vault, "YTD") / Sum(IIf(Fields!Average_Days_from_Title_at_Auction_to_Vault.Value > 0, 1, 0), "YTD"), 0) Report executed successfully but am not getting the values. Please correct where I did the wrong.!
Hi I written below expressions
=Round(Sum(Fields!Average_Days_from_Flooring_to_Title_in_Vault.Value, "YTD") / CountRows("YTD"), 0)
=Round(Sum(Fields!Average_Days_from_Title_at_Auction_to_Vault, "YTD") / Sum(IIf(Fields!Average_Days_from_Title_at_Auction_to_Vault.Value > 0, 1, 0), "YTD"), 0)
Report executed successfully but am not getting the values. Please correct where I did the wrong.!
If you want to round the value 0 then use round function
Round(Fields!GroupAverageAssessment.Value,0)