SSRS Report Builder Part 9.11 - Creating Sum If, Count If and Average If Expressions

[@maksympt1]

these videos are gold and deserve much more

[@WiseOwlTutorials]

Thanks Maks! Happy to hear that you like the videos!

[@dermotnolan176]

Great video, and thank you..... Being a great help...

[@WiseOwlTutorials]

Thanks for watching Nolan!

[@dermotnolan176]

@@WiseOwlTutorials No problem at all - all of these has helped me a lot.....

[@RohithKK-uh7pp]

One more excellent video. Thank you.

[@WiseOwlTutorials]

My pleasure Rohith!

[@maryf5983]

Thank You..... excellent explanation and demo!!

[@WiseOwlTutorials]

Thank you Mary, glad you found it useful!

[@daves4026]

Man of many skills 👍

[@WiseOwlTutorials]

Thanks Dave!

[@sumitthakur2241]

Great video

[@WiseOwlTutorials]

Thank you!

[@sumitthakur2241]

@@WiseOwlTutorials do you have any course on udemy

[@WiseOwlTutorials]

@@sumitthakur2241 Hi there! No we don't have courses on Udemy.

[@sreenuisukapalli-h8l]

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.

[@WiseOwlTutorials]

Hi! Yes, you can see this information in the video description and on the end screen of the video. I hope it helps!

[@thienson9736]

Can you make a video on how to access ssrs via internet instead of localhost?

[@kemidiramesh200]

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)

[@bimalpatel7758]

Sir can we have only true part of iif?

[@WiseOwlTutorials]

Hi Bimal! No, all three parameters of the IIf function are required.

[@paraspatil1201]

Can SUMIIF work for multiple conditions using AND? Just like SUMIFS in excel

[@WiseOwlTutorials]

Hi! You can combine logical tests using the And and Or operators with the IIf function. I hope that helps!

[@nagendranrajaram8871]

Can you explain the syntax

[@tejamarneni]

Thank you for SSRS video. Added to my watchlist. Quick question Andrew, when can we expect Python course from your colleague?

[@WiseOwlTutorials]

Hi Ravi! We don't have a fixed date for release, perhaps within the next month, but it depends!