About AdamCookson

AdamCookson · ‎06-09-2022

Hey, The formula you've used to calculate the cost of sales looks correct, but you're right that the answer you get looks wrong. The 2019 data appears to be accurate, so I'd check the values that you're referencing for 2020, the volumes, unit cost, and the cost growth. Kind Regards Adam

AdamCookson · ‎05-24-2022

Hey, It looks like your target module may not be setup to properly accept the data, or you've got a list issue. Could you include a screenshot of the target modules blueprint view and a shot of the 'Details' on the import error failure, cheers. Kind Regards Adam

AdamCookson · ‎05-20-2022

Hey, What you'll need to do is head over to the blueprint of the module and select the versions you'd like to be applicable: Hope this helps. Adam

AdamCookson · ‎05-19-2022

Hey, From what I can see you're formula logic is correct, but it seems you may be missing the lookup data required. Within your module SYS08, do you have values populated for Start/End Dates, Department and Role? If not you'll need to import them. If these are populated you should get data appearing. For example, SYS08 should look like this: If that module is populated, then I think the only other problem would be that your Employee Drivers module EMP03 is blank. Hope this helps Adam

AdamCookson · ‎05-19-2022

Hey, Afraid I don't have a mac, but looking online it seems the process is similar to a PC. You should be able to import the text file into excel to view the data. This link seems to give a step by step guide for mac users that hopefully is helpful: How Do I Open A Csv File On A Mac? (ifon.ca) Kind Regards Adam

AdamCookson · ‎05-19-2022

No worries, glad to hear that fixed it.

AdamCookson · ‎05-17-2022

Hey, It looks like you may have a filter applied to the tick box grid. If you edit the page and edit the card, you can check what filters are applying to the grid. If there is one applying, removing it should resolve the issue. Kind Regards, Adam

AdamCookson · ‎05-11-2022

Hey, If you need to remove the time dimension, what you'll want to alter is the Time Scale in the blueprint view. If you set this to not applicable for the Demand line item, it will be removed from time and you'll get the subsidiary view. Hope that helps.

AdamCookson · ‎05-05-2022

Hi, I believe the option you'll need to activate is the within the context ribbon and is called the "Hierarchy Filter" when you edit the app page and try to edit the grid in question: With this turned on you will be able to show a specific section of months while having a selector to choose the grouping displayed. In this example it will be the H1 or H2, but this also gives the options to view months related to the full year. Hope this helps Adam

AdamCookson · ‎05-03-2022

Hey, If you go to the page designer then click to edit the grid do you have the following option ticked: If there's no formula in the line item and you're looking at the most granular level of the module, with that option ticked you should be able to edit it from the app page. Hope that helps, Adam

AdamCookson · ‎11-10-2020

Hi, If I remember correctly you should just be able to use Timesum('DAT03 Historic Volumes'.Volumes) without any further values and meet the 'Has Data?' flag requirements. Effectively this will just remove the time dimension from the original value and flag the true/false per account for you. Hope this helps! Kind Regards Adam

AdamCookson · ‎10-28-2020

I would check the spacing on the Unit Price and the % symbol as well, if it's not matching it will throw out an error. As mentioned above, clicking on the line item you want should work around the issue. Adam

AdamCookson · ‎10-28-2020

Hi Nayani, The error looks to be generated as you've set the time to refer to the column headers, if you alter this to refer to the column labeled week then set the appropriate time identify within the time tab of the import mapping you should be fine. Hope that helps. Adam

AdamCookson · ‎11-21-2018

Hi Andre, If you create an export of a module/view you can save the export definition. This will then appear under the export section of the actions menu. If you create a process and include the export action within it you can then publish this to a dashboard. Hope that answers your question. Regards Adam