Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all;
Still a semi-newbie...
I am trying to create a KPI that looks at the previous month only pulling specific data from two different fields. The first field name is "Spec.Stock" and the choices are as follows:
Whse Stock
Consignment
Stock @ Vendor
The second is my values from the field EUR.
This is the expression I have written for a different KPI that looked at the values for the previous months out of field EUR:
sum({<[=[Month.autoCalendar.MonthsAgo]={1}>}EUR)
This worked as planned but what I have been unable to figure out is how to write the expression to just pull the values from the field EUR for "Whse Stock" from "Spec. Stock".
Any advice or pointing me at the correct discussion/stream would be greatly appreciated.
Thanks in advance.
May be this
Sum({<[=[Month.autoCalendar.MonthsAgo] = {1}, [Spec. Stock] = {'Whse Stock'}>}EUR)
May be this
Sum({<[=[Month.autoCalendar.MonthsAgo] = {1}, [Spec. Stock] = {'Whse Stock'}>}EUR)
Sum({$<[Spec. Stock] = {'Whse Stock'}>}EUR) - this expression pulls EUR choices where [Spec. Stock] = {'Whse Stock'} and sums it up.
If u need more filters like month=xyz etc, just keep on adding as suggested above by sunny.
Add those fields in you set expression.
sum({<[=[Month.autoCalendar.MonthsAgo]={1}, [Spec. Stock] = {'Whse Stock'} >}EUR)
Sum({<[Spec. Stock]={'Whse Stock'}>}EUR)
All of you, thank you very much. This is exactly what I needed. As I keep learning hopefully I will not need to keep asking these simple questions.
Again, thanks, I really appreciate it.
Will