There's a field that has Service Types that's labeled "Service Type" the two types of data that need to be combined are Reconstruction and Dry Out.
Service Type Earned
Reconstruction AmountX
Dryout AmountX
I'm trying to combine the dryout and reconstruction totals and only show the ones that are greater than or equal to 1100 in a new report or filter.
OK near as I can tell the Service Type is irrelevant here.
You can simply make a formula numeric field called [Dryout and Reconstruction Total] where the formula is simply:
[Reconstruction] + [Dryout]
Then in a report, under filters:
[Dryout and Reconstruction Total] is greater than or equal to the value 1100
Does it matter that Reconstruction And Dry Out are on their own separate entry? The service type identifies the type of service being billed.
I think you lost me on the structure. Maybe you can post a screen shot to help.
What do you mean 'there are two types of data to be combined'?
I think you need to list how many tables are involved (are any of these values in child tables)? And what exact fields you have on each table.
Right now I am presuming there is a singular table, with 3 fields of interest. Thus, every Record has:
- A Service Type
- A Reconstruction Amount
- A Dry Out Amount
Is this not correct?
It's stating that "reconstruction" and "dryout" are undefined.
I suppose the easiest way to explain would be to alter the formula to what I believe I need.
If so, make a formula numeric field:
var number TotalAmount = [Recon.Amount Field 1] + [Dryout.AmountField 2];
If(
([Service Type] = "Reconstruction" or [Service Type]= "Dry Out") and $TotalAmount > XXX,
$TotalAmount
)
I think the structure is much different than I was picturing. I think you will need to explain the tables and relationships for me to get it, but maybe someone else can understand.
Based off the photo, my formulas will not work. What happens if you have 30 entries, and 20 of them are Dryout and 10 of them are Reconstruction. How do you know which two you want to add up and see if it is over 1100?
------------------------------
Mike Tamoush
------------------------------
