Dynamic Calculated Field based on date Control

[equiazon]

Hi. I am trying to add a calculated Field to get the dynamic value when using the date control. My output is to get the Weighted Target value based on the date control.

For example, 

Day	Task	Target	Weight %	Weighted Target
1	180	180	97.30%	175
2	5	42	2.70%	1
Total	185		100%	176

if my date control is Day 1 only, the Weight Target should show 180

[sam8]

Tricky. I think the only way to "get a dynamic value" would be to use a parameter. In other words, get rid of the date control entirely and replicate its functionality using a parameter instead.

My idea is to reference this parameter in the "weighted target" calculation and in a filter. Something like "If parameter value is 'both', weighted target is target times weight. If parameter value is 1 or 2, weighted target is just target."

Then create a filter that applies the correct day based on the parameter. 

[阿泰]

Hi, in your report settings, did you check this option? Please refer to the screenshot below. There can be different results depending on whether the box is checked or not, so I think this might be the main issue.