Using variables in expression

[rdlccn70]

Hi all,

i have following Expression:

(Sum({<DATA_PERSONAL_EBENE ={'IST'},Jahr_Personal ={'2015'},Monat_Personal=(vPriorMonthPersonal)>[DATA_PERSONAL_WERT]))

Everything is ok, but i have a problem with the variables vPriorMonthPersonal. How can i use this in the Expression?

Thank you.

Regards,

Erdal

[swuehl]

Try like

Sum({<DATA_PERSONAL_EBENE ={'IST'},Jahr_Personal ={'2015'},Monat_Personal={'$(vPriorMonthPersonal)'} >} [DATA_PERSONAL_WERT])

[afernandezblade]

Hi,

Try:

(Sum({<DATA_PERSONAL_EBENE ={'IST'},Jahr_Personal ={'2015'},Monat_Personal={"$(vPriorMonthPersonal)"}>[DATA_PERSONAL_WERT]))

[sasiparupudi1]

The variable must be wrapped in $()

Monat_Personal={'$(vPriorMonthPersonal)'}

[rdlccn70]

Hi, thank you ver much. it works with Monat_Personal={'$(vPriorMonthPersonal)'}, bu i have another question.

How can Change a number in two Digits like this

My vPriorMonthPersonal is numeric and i Need in two Digits. Is there a function like Format??

Regards

Erdal

Numeric	two digits
1	01
2	02
3	03
4	04
5	05
6	06
7	07
8	08
9	09
10	10
11	11
12	12

[rdlccn70]

Hi it works with '....', not with "...". Thank you.

[swuehl]

Use

num(FIELD, '00')

[rdlccn70]

perfect, thank you.

[oknotsen]

If your question is now answered, please flag the Correct Answer.

If not, please make clear what part of your question you still need help with .