Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Can anyone tell me difference between these two expressions
1. Sum({$<[Fiscal Year Full]={"$(=$(vCurrentFY))"}>}[Sales])/
Sum({$<[Fiscal Year Full]={"$(=$(vCurrentFY))"}>}[Qty ])
(This KPI shows correct KPI data for Fiscal years but if I pick one Order number its shows blank)
2.
Sum({$<[Fiscal Year Full]={"=$(vCurrentFY)"}>}[Sales])/
Sum({$<[Fiscal Year Full]={"=$(vCurrentFY)"}>}[Qty ])
(This KPI shows correct KPI data for an particular Order number but by default consolidated FY data is wrong)
How is the variable vCurrentFY defined? Does it output value change when selecting an order number?
HI,
Variable is not changing when I selected that order number its still says 2019
PS: That or no is from 2018
LET vCurrentFY = PEEK('FY', 0 ,'Calender');