different data time reporting

[JoseGarcia]

Hi there, 

I have different data that is reported on different time frames. 
For example, I have data that is reported daily, and data that is only reported monthly on the 1st of every month.

The data that is reported on the 1st of every month, if a date selection is made which is not the 1st of the month, the data is not showing, this is obvious.

What formula could I use for these type of data to show for the whole month period?

Thanks a million for your support.

Regards

Jose

[lironbaram]

Hi
you should have the data in two tables , in the daily table and field using monthstart(Date) and connect the tables using this field

[JoseGarcia]

Lironbaram, 
Thanks for your reply. 
Below is the full formula for the data that is reported monthly.

Sum([1EHS02]+[1HS03]+[1HS05]+[1HS10])/sum([1HS06]+[1HS11])*1000000

can i suggest the following: 

if(monthstart(date),Sum([1EHS02]+[1HS03]+[1HS05]+[1HS10])/sum([1HS06]+[1HS11])*1000000)

Is this correct?

Thanks a million