Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a input control which stores date in a variable say vDate. I have two fields Inception Date and Expiration Date. Based on the value in input control I need to get the results in Straight table or Pivot table with the condition Where Inception Date>= vDate and Expiration Date <= vDate.
I got this working by using below.
sum({<InceptionDate={"<=$(vDate)"},ExpirationDate={">=$(vDate)"}>}Sales)
Hi
try this if(Inception Date>= vDate and Expiration Date <= vDate,DimName)
hi,
If you want to use this condition for an expression then u can use set analysis:
sum({<Inception Date={">=$(vDate)"},Expiration Date={"<= $(vDate)"}>}FACT)
and if you want to use in dimention then you can follow expression as given by nirmal.
if(Inception Date>= vDate and Expiration Date <= vDate,DimName)
HTH
Sushil
I got this working by using below.
sum({<InceptionDate={"<=$(vDate)"},ExpirationDate={">=$(vDate)"}>}Sales)