set analysis with variable

[ilanbaruch]

hi all,

i have a variable (vSysHour) with system hour, i want to calculate amount where hour dimension is small or equal to variable value.

tried it like this:

Sum({$<HOUR={"'<='$(vSysHour)"}>}Amount)

it didn't worked..

any ideas?

advanced thanks

[shraddha_g]

Remove single quotes from expression.

[Chanty4u · Accepted solution]

try without single quote

Sum({$<HOUR={"<=$(vSysHour)"}>}Amount)

[sunny_talwar]

May be like this:

Sum({$<HOUR={"$(='<=' & vSysHour)"}>}Amount)

or

Sum({$<HOUR={"$(='<=' & $(vSysHour))"}>}Amount)

[jonathandienst]

Is vSysHour a numeric or a string? How is it defined? What do =vSysHour and =$(vSysHour) look like in textboxes?

What is HOUR (hours as a numeric, a string time value, a datetime value of hours)?

The answer will be something like:

Sum({$<HOUR={"<=$(vSysHour)"}>}Amount)

Sum({$<HOUR={"<=$(=vSysHour)"}>}Amount)

Sum({$<HOUR={"<=$(=Time(vSysHour))"}>}Amount)

Sum({$<HOUR={"<=$(=Time(Time#(vSysHour, 'xxx'), 'yyy')"}>}Amount)

(replace xxx with format of vSysHour and yyy with format of HOUR