Jump to content

Portal Problem with Calculations


Keith42
 Share

This topic is 5605 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am having trouble getting a portal to display records that are related using a calculation.

The Portal is in the Third_party_Payers Database.

I am trying to get a list of all the patients who are on account with a particular provider (third_party) and owing using a calc of a line items scenario whereby the fee is taken from the paid producing a calculation that is “Owing” or “Paid”

My portal stubbornly refuses to show just the “Owing” but rather all patients of that provider.

I am at a loss and am sure that it is something simple but it is well beyond me.

I have attached my stumbling effort for all to laugh at! Any help would be very gratefully received.

Link to comment
Share on other sites

  • Newbies

Hi Thanks very much for replying.

I dont quite understand what you mean though. I have tried relating the files using the number field calculated when the fee is taken from the paid and still no joy.

Thanks for your time.

Keith

Link to comment
Share on other sites

I have tried relating the files using the number field calculated

No exactly, it's on the wrong side of the relation ...the one requirering the indexing to work.

I need to think up a solution to your problem, which perhaps is likely to be approached with a different relational structure.

Or perhaps a more transaction'ish approach.

--sd

Link to comment
Share on other sites

This topic is 5605 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.