Day wise Budget logic help.

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

I have the following table

Budget:

load * inline

[

Plant,Month ,Value,Day

P1,Jan,100,MO

P1,Jan,105,TU

P1,Jan,108,WE

P1,Jan,95,TH

P1,Jan,74,FR

P1,Jan,120,SA

P1,Jan,130,SU

];

now want the data, Same day of the Month has same Budget.

ex:- Budget of all Mondays of Jan should be 100, Budget of all Tuesdays of Jan should be 105 and so on.

Please help me out to right the same logic.

Thanks,

Lalit Kumar

Re: Day wise Budget logic help.

sunny_talwar — Mon, 15 Jan 2018 12:40:08 GMT

Connect your Budget Table to the Master calendar on Month and Day field... Have you tried this already?