Calculated Dimension for Greater than

[#1]

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

[#2]

Try something like the following expression:

sum({$<DOH_Start={"<=$(vOneYearBack)"}>} YourField)

Make sure that your date formats match exactly.

[#3 · Accepted solution]

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

[#4]

Thank you for your support everyone. Sivaraj and Rebeccad this would work for an expression, but not for a dimension calculation.