Comparing Greater Than Text Issue

[calvin_wee]

Hi All,

We need to implement a new Forecast Version Selection variable [vFcsVers] to show all future forecast version [FCST VERSION].

Before the change, we have this and it has been working fine.

num(

  sum({<

        [Fcst Version]=,

        Sys_FcstVersion=,

        [Reporting Month]={">=$(vMinMth)"},

        [Fcst Month]={">=$(vMinMth_1)"}

        >}

        Amount),'#0.0')

We added the comparison but it is not working as expected.

num(

  sum({<

        [Fcst Version]={"=[Fcst Version] follows '=$(vFcsVers)'"},

        Sys_FcstVersion=,

        [Reporting Month]={">=$(vMinMth)"},

        [Fcst Month]={">=$(vMinMth_1)"}

        >}

        Amount),'#0.0')

Output will be a cross table with all the Versions (After the selected version) showing on the left and Sum(Amount) as Expression.

Any advise is appreciated.

Thanks in advance & Best Regards

[tresesco]

Are you planning to select multiple values? Have you considered getting them formatted in the variable  accordingly? for single value try like:

  [Fcst Version]={'$(vFcsVers)'},

[marcus_sommer]

I think I would try to use a numeric value for [Fcst Version]. It might include a period-value and a creator-id, type-id (best, real, worse) and also a version-number. Depending of your creating and/or storing of these forecast-data it might be possible to create this number with an autonumber().

- Marcus

[calvin_wee]

We need to have multiple values and this is not workable.

Thanks

[calvin_wee]

The alpha is needed as it is denoting the year in this case making comparing the number is not possible.

Thanks

[calvin_wee]

We managed to resolve using restrictions on Dimension. But we are still interested in getting the above in a formula via expression. Thanks and please keep suggestion coming.