Using "Day" field to divide by

[Anonymous]

Hello. I am trying to us the Day field in my expression to divide by. As shown below option 1 works I receive a % amount but in option 2 I receive a blank return.

=Sum(HdmsARAmount)/(Sum(HdmsClaimOtherAdjustments + HdmsClaimMACReductions + HdmsClaimRefunds + HdmsClaimGrossCharge)/30))

=Sum(HdmsARAmount)/(Sum(HdmsClaimOtherAdjustments + HdmsClaimMACReductions + HdmsClaimRefunds + HdmsClaimGrossCharge)/Day(MonthEnd(HdmsClaimDateOfService)))

I would really appreciate any help on this.

Cliff

[sunny_talwar · Accepted solution]

May be you need Min or Max function around HdmsClaimDateOfService?

=Sum(HdmsARAmount)/(Sum(HdmsClaimOtherAdjustments + HdmsClaimMACReductions + HdmsClaimRefunds + HdmsClaimGrossCharge)/Day(MonthEnd(Max(HdmsClaimDateOfService))))

[Anonymous]

Thank you I will try this and let you know. Thank you again.

[Anonymous]

Hi Sunny you are the best! Thank you so very much for this help and so quick. I really appreciate this.