Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have created a variable in front end as below
vAvailable_Stock ---> sum(Stock_A) + sum(Stock_B)
with no equal sign, because i want it dynamically with selections.
In front end i have created a KPI with below expression
Week(Max({<Sum_Orders={"<= $(vAvailable_Stock)"}>}Week_Start_End_Week_Count))
This should bring the week number, but is giving null.
I already checked with hard coded value as below and it is working.
Week(Max({<Sum_Orders={"<= 600000"}>}Week_Start_End_Week_Count))
Please suggest
Thanks
Even i tried this
Week(Max({<Sum_Orders={"<= $(=vAvailable_Stock)"}>}Week_Start_End_Week_Count))
The below expression worked
Week(Max({<Sum_Orders={"<= $(=$(vAvailable_Stock))"}>}Week_Start_End_Week_Count))