Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this may be:
BUDGET:
LOAD MOIS,
ANNEE,
COMPTE,
SECTION,
MONTANT,
ANNEE*12+Num#(MOIS) as Periode
Resident BUDGET_DATA;
Try this may be:
BUDGET:
LOAD MOIS,
ANNEE,
COMPTE,
SECTION,
MONTANT,
ANNEE*12+Num#(MOIS) as Periode
Resident BUDGET_DATA;
Thanks Sunny
with your help,
it's Num(Num#(MOIS))
I don't think you need the extra Num(). Have you looked at the attachment?
ok i have not see the attachment ...
that it's ok too
thanks for all
have a good day
Not a problem. Have a good one.
Best,
Sunny