Hi I written below expression to for my calculated fields and my reporting executing without fail, but am not getting any result in those fields. Please correct me where I did the wrong. Thanks in advance. =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)
these videos are gold and deserve much more
Thanks Maks! Happy to hear that you like the videos!
Great video, and thank you..... Being a great help...
Thanks for watching Nolan!
@@WiseOwlTutorials No problem at all - all of these has helped me a lot.....
One more excellent video. Thank you.
My pleasure Rohith!
Thank You..... excellent explanation and demo!!
Thank you Mary, glad you found it useful!
Man of many skills 👍
Thanks Dave!
Where we can find the total Play list, if you don't mind please provide the link where we can watch all pay (paginated Report Builder list.
Hi! Yes, you can see this information in the video description and on the end screen of the video. I hope it helps!
Great video
Thank you!
@@WiseOwlTutorials do you have any course on udemy
@@sumitthakur2241 Hi there! No we don't have courses on Udemy.
Hi I written below expression to for my calculated fields and my reporting executing without fail, but am not getting any result in those fields. Please correct me where I did the wrong. Thanks in advance.
=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)
Can you make a video on how to access ssrs via internet instead of localhost?
Thank you for SSRS video. Added to my watchlist. Quick question Andrew, when can we expect Python course from your colleague?
Hi Ravi! We don't have a fixed date for release, perhaps within the next month, but it depends!
Can SUMIIF work for multiple conditions using AND? Just like SUMIFS in excel
Hi! You can combine logical tests using the And and Or operators with the IIf function. I hope that helps!
Can you explain the syntax
Sir can we have only true part of iif?
Hi Bimal! No, all three parameters of the IIf function are required.