Calendar Logic help

[abhaysingh]

Hi Guys,

i have one sales table in which year and week are available as per calendar year,

i need to concatenate it into Budget Table on the basis of common key,

Problem is i have the of budget in the form fiscal year,

when i m concatenating celandar year and fiscal year are mismatching, and data not validating,

so i want how i can create fiscal year w/o multiplying my record in Sales Table so i can easily concatenate tables?

pls suggest

[Anonymous]

I am assuming you are having like this for your budget, 2013-2014, 2014-2015 ....

Convert it into normal calender year, like this?

can we try like this at script?

mid(FinanceYear,1,4) as SalesYear

or

subfield(FinanceYear,'Your Delemiter',1) as SalesYear

Then concatenate both the sales year

[abhaysingh]

i have fiscal year like 2012,2013,2014,2015 and there month Apr, May to Mar,

and sale data is like 2016,2017,2018 etc

now 2016, Jan is 1 month for SalePlan,

and for budget Jan is 10 month , and year change to 2015 as per fiscal calculation.

[Anonymous]

Sound Good ,

then use Link table, create two flag one for Sales and one for Budget....

Leave it on customer how they want to see as both are into different view?