creating a date field

[himanshi]

hi community,

i have a table in which i have year and month field and a quantity field now i need to display quantity for all dates of a month.

how to do that i don't have a day numbers.

in the below attachment file i need to display the same sales plan for each date of a month instead of 1 only.

Regards

[dinuwanbr]

Hi,

That means u need to load all the dates and where there is no sale then it as zero. Am I correct?

Better if u can upload a sample.

BR,

Dinu1

[himanshi]

Hi Tharindu Ranathunge,

thanks for reply‌. yes you are correct somewhere their is data for month only. and its done  i have used this expression-

=sum({<[Common Day Number] =>}total<[Common Fiscal Month Name],[Common Year Display]>CommonQty)

Regards,

Himanshi

[t_chetirbok]

Hello!

Maybe this will be helpfull!

[nilesh_gangurde]

Hi,

In Datamodel Link your plans on the Monthname Field. Dont Link the plans on the Date Field. Currently you are linking on the basis of Date, change it to Monthname.

This will automatically Show plans for each day of the month.

Regards,

Nilesh