Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Assign Missing Dates With Zero for Value

Hi, I have a list of [Projects] each project has a [Date] and a [Value]. The dates are by month, eg. 2014-12-01 Some of the projects don't have any data for some months. I need them all to show al...
Need Help
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

 

Perhaps you need the IF function to replace the missing date with 0.