calculating datediff for a report

[GayatriPatelCSA]

Creating a very simple Project report to show dates at project level and weekday difference between them. Two dates listed for the project are custom form dates - PredicationStart and PredicationEnd. But, my attempt to show the weekday difference is turning futile. What am I missing?

Valueexpression=WEEKDAYDIFF({DE:PredicationEnd}, {DE:PredicationStart})
displayname=Weekday Difference
valueformat=HTML

[KellieGardner]

You need to lowercase the "valueexpression".

Additionally, the custom fields should maintain their formatting as they are setup in your system likely with spaces like this:

valueexpression=WEEKDAYDIFF({DE:Predication End}, {DE:Predication Start})

[GayatriPatelCSA]

Thanks, Kellie. I did have everything in lowercase and it was still not working. So, I just added a calculated field in the custom form itself and then added that in the report. I wanted to avoid taking the extra step if there was a way to directly calculate the difference in the report.

[KellieGardner]

can you screenshot your field in the report and then your calculated field for me to look at? 

[GayatriPatelCSA]

Not sure why the report shows the values today (it did not yesterday). But the weekday difference field is showing the value as the calculated field (Predication date diff - that I added to the form yesterday) shows.

This is the form attached to each project with the calculated fields.

[KellieGardner]

Thanks. From your screenshots, I can't tell what the text mode is for the calculated column in your report. But based on what I see for your calculated field, you created, this formula should work in reporting text mode:

valueexpression=WEEKDAYDIFF({DE:Predication End}, {DE:Predication Start})

The only thing I can think of is that in your original post, you had the V capitalized, and it should be lowercase. Plus, you need the spaces in the field names.