Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to get a calculated dimension for DOH_Start greater than vOneYearBack.
DOH_Start is mm/dd/yyy and vOneYearBack is 12/31/2012.
Any ideas please.
Thank you,
Oneputtgirl
Hi Oneputtgirl,
try this to create a calc dim with DOH_Start:
=if(DOH_Start >= '$(vOneYearBack)', DOH_Start)
May be you have to check "Suppress when Value is Null" for this dimension.
HtH
Roland
Try something like the following expression:
sum({$<DOH_Start={"<=$(vOneYearBack)"}>} YourField)
Make sure that your date formats match exactly.
Hi Oneputtgirl,
try this to create a calc dim with DOH_Start:
=if(DOH_Start >= '$(vOneYearBack)', DOH_Start)
May be you have to check "Suppress when Value is Null" for this dimension.
HtH
Roland
Thank you for your support everyone. Sivaraj and Rebeccad this would work for an expression, but not for a dimension calculation.