Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I have a requirement in which I need to calculate\
expression1 = Sales* quantity LFY/ weight* Quantity LFY
Note : LFY is last fiscal year and I have a column name LYear column have fiscal year
for quantity LYD I did = Sum({$<Year={$(=Max(LYear)-1)}>}quantity)
but when I try to multiply it with
Avg(Sales * Sum({$<Year={$(=Max(LYear)-1)}>}quantity))
/
Avg(price * Sum({$<Year={$(=Max(LYear)-1)}>}quantity))
it gives me no output. Any idea where ist going wrong.
Try
( Avg({<Year={"$(=Max(LYear)-1)"} >}Sales ) * Sum({<Year={"$(=Max(LYear)-1)"} >}quantity) )
/
( Avg({<Year={"$(=Max(LYear)-1)"} >} price )* Sum({<Year={"$(=Max(LYear)-1)"} >}quantity) )
-------------------------
You have to add set for Avg() also, Set Analysis is calculated Once Per Chart not at every row.
Try
( Avg({<Year={"$(=Max(LYear)-1)"} >}Sales ) * Sum({<Year={"$(=Max(LYear)-1)"} >}quantity) )
/
( Avg({<Year={"$(=Max(LYear)-1)"} >} price )* Sum({<Year={"$(=Max(LYear)-1)"} >}quantity) )
-------------------------
You have to add set for Avg() also, Set Analysis is calculated Once Per Chart not at every row.
Same expression I have to calculate as LYTD ie last year to date. can u help
Avg(Sales * LYTDquantity))
/
Avg(price * LFYquantity