How can I multiply the value of the current week by a number?

[BenGielen]

Hello together,

i have a question. I want to multiply the number of the actual week with a fix value. 

For example:

WeekNo. 30 x 150000 = 4,5M

the result should be a target for a diagramm. 

is there anyone who can help me to solve this?

[JordyWegman · Accepted solution]

Hi Ben,

Try this:

let vFixedValue = 150000

Table:
Load
   WeekNo * $(vFixedValue) as Value
   WeekNo
From [YourSource] (qvd)
;

Or if you don't want to do it in a script, use this formula in a table and create the variable in the variable overview:

let vFixedValue = 150000

Measure: WeekNo * $(vFixedValue)

Jordy

Climber

[BenGielen]

Thank you for your fast support. It works.