Calculated Day Factor in Report Builder

Hi, Anonymous 

Report Builder uses VB.NET-based expressions. You'll need to use the functions available in Report Builder to implement similar calculations.

CurrentDate=Max(Fields!TapeDate.Value)

DaysInMonth=DateDiff("d", DateAdd("m", 1, DateSerial(Year(Fields!TapeDate.Value), Month(Fields!TapeDate.Value), 1)), DateSerial(Year(Fields!TapeDate.Value), Month(Fields!TapeDate.Value), 1))

DaysInYear=DateDiff("d", DateSerial(Year(Fields!TapeDate.Value), 1, 1), DateSerial(Year(Fields!TapeDate.Value), 12, 31)) + 1

AdjustmentFactor =DaysInYear / DaysInMonth

The final=IIf(Sum(Fields!AvgBook.Value) = 0, 0, (Sum(Fields!CLC_Withdrawal.Value) / Sum(Fields!AvgBook.Value)) * AdjustmentFactor)

 You can create a calculated field or use these expressions directly in a report item (e.g., text box, table).

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.