RossLeahy_AVT Red Ribbon

Thanks Patrick, Think I have been looking at all of this so long my eyes do see half of what they should

Thanks @Patrick Fresnosa-Oracle I got some great one-on-one from the PS team yesterday as well. I built the Margin calculation into the dataset as well. How do I format a Workbox Calculation to present as a % (Margin/Income)*100 doesn't pass muster as it doesn't like *100

Hi @Patrick Fresnosa-Oracle Yes - I could calculate the margin in the dataset when I get some help with the SQL. Will see if one of our developers can spare a little time

So, calculate the Gross Margin in the dataset? Possibly a challenge for my SQL but I will have a try

Hi I have made progress, but here is the next challenge. I want to add two columns - Income - Cost of Sales to be labelled margin, and the other to be Margin/income as %. Simply totalling the row gives me the correct answer but no labelling option. Calculated measures don't work. Do I need to build this into the dataset?…

Quick Question - is that a subsidiary setting or purely company - I have one client with a mix of calendars

@Patrick Fresnosa-Oracle thanks - two workbooks is fine. My emerging challenge is fiscal years - Australia uses July/June which makes using dates difficult. How do I factor 'Last Fiscal Year', Last Fiscal Year to Date, This Fiscal Year into work books? Should I be doing it in the dataset? Other issue is the reversing of…

Hi can I also add reversing signs - Income to show positive and COGS/Expenses negative

Thanks for responding It was in the SuiteAnalytics reporting section. Support has advised such functionality is not available. Ross