Manipulating a Formula from Saved Search to Analytics Workbook

Hoping t o find Analytics wizard to help me think of a solution to an issue I am having in some design work I am performing. Details below, I think it could be an Analytics issue as I am able to create what I am after in Saved searches but can’t replicate in Analytics.
Idea: Creating a Supply Graph in Analytics Workbooks that shows aggregate inventory position on a daily basis determined by Sales Orders, Production Orders and Opportunities (utilised as forecasted demand).
I have been able to create this in a saved search. I am having issue replicating the formula  into analytics.

Saved Search Formula:
sum/* comment */(CASE WHEN {type} LIKE ‘Production Order’ THEN {Quantity} ELSE ({Quantity}*-1) END) OVER(PARTITION BY {item} ORDER BY {trandate},{internalid},{linesequencenumber} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

 

Add Comment
1 Answer(s)
Best answer

Are you sure the /* comment */ trick works in suiteanalytics?  I believe that is more of a hack in saved search than an actual feature of them.

Intermediate Answered on July 31, 2020.

Hi,
This is why I asked the question, as I need someone to assist converting it from a saved search hack to an analytics hack.

on August 4, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor