crosstable + calculated field

[pirotfab]

Hello,

I want to creat à calculated fiels (periode) to join my calendar and ma crosstable (budget).

Periode = year*12+month

year*12 it's ok but when i add the month, it comes out an error

If someone have an idea

thanks

[sunny_talwar · Accepted solution]

Try this may be:

BUDGET:

LOAD MOIS,

  ANNEE,

  COMPTE,

  SECTION,

  MONTANT,

  ANNEE*12+Num#(MOIS) as Periode

Resident BUDGET_DATA;

[pirotfab]

Thanks Sunny

with your help,

it's Num(Num#(MOIS))

[sunny_talwar]

I don't think you need the extra Num(). Have you looked at the attachment?

[pirotfab]

ok i have not see the attachment ...

that it's ok too

thanks for all

have a good day

[sunny_talwar]

Not a problem. Have a good one.

Best,

Sunny