topic Splitting the data into 12 months in App Development

Splitting the data into 12 months

Aspiring_Developer — Wed, 05 Feb 2020 11:27:20 GMT

Hi ,

I have the below scenario:-

Table1:

Crosstable(Months, Value,2)Load

Budget,

Actual as Flag,

April,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec,

Jan,

Feb,

Mar

From ....

I have "Budget" and suppose it has a value say 25000 and it i have to divide it by 12 and show the each value with respect to months. But i do not have any month specific values for "Budget".

The above Apr to Marc has the values for "Actuals" but i don't have any months for "Budget".

How should i divide the value of budget by 12 and show each value for months ?

Budget April, May, Jun,Jul,Aug,Sep,Oct,Nov,Dec,Jan,Feb,Mar

25000, values1, value2, value3(25000/12)

Note: Both the values of Actuals (monthwise) and Budget are in the same table

Re: Splitting the data into 12 months

Kashyap_R — Wed, 05 Feb 2020 11:34:34 GMT

Please go through the attachment I have distributed sample budget across all months

Hope this helps

Thanks

Re: Splitting the data into 12 months

Aspiring_Developer — Thu, 06 Feb 2020 06:36:27 GMT

Thanks for the above solution but i want to display the data like this:-

But i have to show the data like this:-

TABLE 1:

Object No,

Country

Element

Project Type

Table 2:

Crosstable(Months, Values, 7)load

Object No,

Ledger No

....

'Actual' as Flag,

Budget,

April,

...

Mar

Master calednar:

Date // linked with table 2

Budget:

Load *,

Budget

Join

Load * Inline[

Jan,

Feb....

Dec]

Final:

Load *,

Num(Budget/12) as Buget

Resident Budget

Drop table Budget

I want to create a link between Table1 and Budget on the "Object No". But when i ma trying, getting error "Ciruclar reference". How should i create a link between these two table so that i can fetch the value of budget with respect to "ObjectNo". Please help !