target

[fmazzarelli]

Hi Community,

my monthy target is 85.

I'll wish create a dynamic target.

Formula is: month * 85

Example:

01 (January) * 85 = 85

02 (February) * 85 = 170

03 (March) * 85 = 255

Perhaps I need to convert 01 to number and then *85

But which is the instruction?

Fabio M

[sunny_talwar]

May be like this:

LOAD Num(Month(Date)) * 85 as Target

FROM Source;