Hi I want to check the increase or decrease of the count from previous day data to current data and fill the background color with green if +10% ,red for other. Please show me how to do it? Thanks.
how to use running value in footer or header. Can you please help me with this as I want to show the total in the footer. If running value can't be used in footer please please please help me with alternative better solution
Good quality videos as always. You dont know how many times you've saved me. A quick question, is there a way to nest running value inside of a running value? Eg: RunningValue( (runningvalue(a,sum,nothing)/ runningvalue(b,sum,nothing)),avg,nothing)
@@WiseOwlTutorials How about a window period to calculate running total. Like the windowing function in SQL. Is it possible to do that with the running values here??
You can use the StrConv function with the vbProperCase constant docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/strconv-function I hope it helps!
@@WiseOwlTutorials I have a table with 2 groups. The child groups has a group variable which is a calculation (it takes a single value minus the sum of all fields in that group). I show these group variables in the group header and hide the detail rows. Now, I just need to take the total of all the group variables in that column and display it after the table or in the footer. I've Been running into report builders issue of you can't aggregate group variables and I've found no way around this yet without redesigning the whole report
I just wanted to say that I really appreciate your videos. They have been very helpful for me!
Happy to hear that the videos helped, thanks so much for watching!
I just love your videos , you doing some great work here buddy. Keep waiting for your videos here. Got to learn so much . Thanks ❤️
Thanks Sudipto! Happy to hear you're enjoying the videos, thanks for watching!
I do enjoy your videos and also appreciate what you are doing. Get to learn a lot . Thanks for your efforts.
Thanks man, it helps a lot.
Appreciate your Effort.
You're very welcome, thank you for watching!
awesome
Thanks!
Hi I want to check the increase or decrease of the count from previous day data to current data and fill the background color with green if +10% ,red for other. Please show me how to do it? Thanks.
Hi Roopa! You might find this video on conditional formatting useful th-cam.com/video/2QvryQwqK_g/w-d-xo.html
I hope it helps!
how to use running value in footer or header. Can you please help me with this as I want to show the total in the footer. If running value can't be used in footer please please please help me with alternative better solution
Good quality videos as always. You dont know how many times you've saved me.
A quick question, is there a way to nest running value inside of a running value?
Eg:
RunningValue(
(runningvalue(a,sum,nothing)/ runningvalue(b,sum,nothing)),avg,nothing)
Hi Nick! No, you can't nest RunningValue functions.
@@WiseOwlTutorials How about a window period to calculate running total. Like the windowing function in SQL. Is it possible to do that with the running values here??
Is there any INTICAP Function here sir? First letter capital
You can use the StrConv function with the vbProperCase constant docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/strconv-function
I hope it helps!
I'd find it useful if you could use a running value to count the number of group rows your have
Hi! Just checking, are you trying to find the number of rows inside a group? Or the number of groups in the table?
@@WiseOwlTutorials I have a table with 2 groups. The child groups has a group variable which is a calculation (it takes a single value minus the sum of all fields in that group). I show these group variables in the group header and hide the detail rows. Now, I just need to take the total of all the group variables in that column and display it after the table or in the footer.
I've Been running into report builders issue of you can't aggregate group variables and I've found no way around this yet without redesigning the whole report