very sorry but i dont know how to add all images at once..
and here goes third :)
and last. :)
pls first see third image..there i have enterd few entrys with category contractor..then see second image..in that portal total is wrong..even project agreed amount is less than total of contractor agreed amount..which should not be..i dont know how to put all this in front of you..coz i said i am new..so i did this..hope you guyz help me in simple and detailed language..
thanx in advance..
and i am waiting..
I don't see an error in that screen shot. I see portal values of: 20,000; 2,000; 55,000 and 35,000. The sum of those values is 112,000--exactly the total shown in field below the portal.
Thousand separators should never be entered for a number value used as a number. It should be supplied by data formatting. In some locations of the world, the comma marks, the position of the decimal point and in others it's the period. And different characters can be used as the thousands separator. But I've never seen a format that looks like 10,00,000 so I do not know how to interpret the commas in that example. But the characters used for the decimal and thousands separator can be specified in data formatting and also are determined by your OS locality settings and what options you select for FileMaker in terms of using those locality settings.
There are any number of ways that you can get a sub total for each contractor. The method to use depends on the design of your layout and what version of FileMaker that you are using as FileMaker 12 and newer offers an additional option not possible with older versions.
Two methods are described here: Sum_Calculation based on condition
A summary report can also be set up where you pull up a found set of records and sort them to group them (such as by contractor ID) by a common value in order to show a sub total for each. The individual records that produce that sub total need not be visible in that report: Creating Filemaker Pro summary reports--Tutorial
And FileMaker 12 or newer developers can use ExecuteSQL: Creating Filemaker Pro summary reports--Tutorial
FileMaker Pro does have a Dial Phone script step. This will work only with FileMaker Pro under Windows operating system, and also FileMaker Go.
Once the data has imported, you can have a script that loops through the records and dials a number. If no answer, you will have to manually select the next phone number to try. Once completed with the record, you can skip to the next record. If you have a script trigger OnRecordLoad, it can activate the script.
Let me know if you need additional clarification.