Variable in Set Analysis

[#1]

Hi Guys,

I have the following expression: sum({<PayRate={$(V_PayRate)}>Hours). What I want to do is create a between clause. So payrate is between v_payrate and some other variable expression I want to list. Currently it just says = v_payrate

Please help

Thanks,

Byron

[Miguel_Angel_Baeyens · Accepted solution]

Hello Byron,

The general rule for syntax is

Sum({< PayRate = {'>=$(vVariableFrom)<=$(vVariableTo)'} >} Hours)

Anyway, check this file to see how set analysis works with date ranges.

Hope that helps.

[gandalfgray]

Hi Byron:

something like this

sum({<PayRate={">=$(vMinPayRate) <=$(vMaxPayRate)"} Hours)

[#4]

Thanks Gandalf... I see I can only mark 1 as correct now