LisaSell1
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Color coding chart inconsistencies
Thank you, Mike, This was what I suspected - you have saved me a lot of time I would have spent trying to solve this. This sort of thing makes it difficult to 'sell' my team on the advantages of reporting in QB. I will add my vote to the user feedback and hope for some future update. ------------------------------ Lisa Sell ------------------------------Color coding chart inconsistencies
Hello, I am wondering if this is not possible: I set up a timeline report with custom colors for 10 different groups. Now I have a request to create stacked bar charts for these same groups using the same custom colors. When I try this, I get the message 'Legend: Colors will be assigned automatically. Either no records match the filter right now, or a report formula is chosen as the series.' The hex codes display as the legend on the chart, so if the charts are on the same dashboard, the colors are meaningless. Would a formula rich text field get around this, or is colorization on a stacked bar chart not customizable? ------------------------------ Lisa Sell ------------------------------Re: Save and Keep Working Button
Hi Daniel, I'm glad you posted the link to the code pages - I just tried this myself Make your field a formula Rich Text field to make the button work. You may also want to adjust the Advanced table settings & check the option 'Auto save when redirected away from the page.' ------------------------------ Lisa Sell ------------------------------Re: Bar Chart Assistance Needed
Hi Lynne, I have attached a screen shot of what I have done. I have a table of Invoices and I used fields Dates and Amounts. First, in your bar chart report, make a Numeric report formula (named 'month group') =Month([Date]). Use 'month group' as category label on x-axis, and group by equal values. Also note it is used for sorting low to high (so 1 =January, 2 = February, etc.). I used the summed invoice amount as the data values on the y axis, the series is the invoice Date, grouped by year. Hopefully you can apply this to your own chart. ------------------------------ Lisa Sell ------------------------------Re: How to find no of Sundays in a Month
Hi, I think I have a solution in the screenshot below. The formulas are to the right of the fields Enter any date in field Date2 calculated date field bom-date2= FirstDayOfMonth([Date2]) Day of week-bomdate2 =DayOfWeek([bom-date2]) eom-date2 = LastDayOfMonth([Date2]) days in date2 month=ToDays([eom-date2]-[bom-date2])+1 first sunday of month= Case([Day of week-bom-date2],0,[bom-date2], 1,[bom-date2]+Days(6), 2,[bom-date2]+Days(5), 3,[bom-date2]+Days(4), 4,[bom-date2]+Days(3), 5,[bom-date2]+Days(2), 6,[bom-date2]+Days(1) ) Sundays =Ceil(ToDays([eom-date2]-[first sunday of month])/7) Days in month - no Sundays = [days in date2 month]-[Sundays] ------------------------------ Lisa Sell ------------------------------Re: Add decimals to the right of a text field
This works on my test report. I'm sure there are better ways to do this, but here is my update: "<span style=\"font-size:11px;\">" & "<b>" & "<span style=\"text-decoration:underline;\">" & "<p style=\"text-align: Right;\">" & var text costnote =ToText([Cost Notes])&".00"; var text notetwo =ToText([Note 2 Cost])&".00"; var text notethree =ToText([Note 2 Cost])&".00"; var text notefour =ToText([Note 2 Cost])&".00"; var text VerticalList = (List (" <br />", $costnote, $notetwo, $notethree, $notefour )); If([Cost Notes]>0, //$VerticalList <> "", "$" & $VerticalList) &"</p>" & "</span>" & "</b>" & "</span>" ------------------------------ Lisa Sell ------------------------------Re: Add decimals to the right of a text field
Hi Mike, I tried your formula in a Rich Text field. All you need to update is this: ToText([Cost Notes]) &".00", ToText([Note 2 Cost]) &".00", ToText([Note 3 Cost]) &".00", ToText([Note 4 Cost]) &".00")); ------------------------------ Lisa Sell ------------------------------Re: Counting Months based on two date field with rounding
I tried this: var date SD=[Actual Start]; var date ED=[Actual End]; var number NumMonths = Floor(ToWeeks([Actual End]-[Actual Start]) /4.345); $NumMonths I made a formula on the report & specified 2 decimal places - you may have to adjust the rounding
