Hi, question please. How can I sum up #transactions #1-#5 without adding the top list (alo world)? The total should only be 249 but the values is 5,772. I already edit the summary method to formula. Thank you.
Try changing the formula to IF PARENT(ITEM('CFO Highlights....')) = 'CFO Highlights....'.Alo World THEN 1 ELSE 0That should work!Although I have to say, this kind of hardcoding is almost never a good idea. Do consider using another approach...Regards,Anirudh
Hi, I changed the summary method to SUM, it got result however the values for the ALO world changed to zero value.
I tried to do a test IF item(list.alo world) condition here but got an error, maybe because the list that I used in my module has a parent list. see ss:
here are my dimensions:
here is the list:
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
