Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)'},
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
We need to have multiple values and this is not workable.
Thanks
The alpha is needed as it is denoting the year in this case making comparing the number is not possible.
Thanks
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.