Jump to content

need Help


saghira
 Share

Recommended Posts

  • Newbies

I have these  fields

amount 1  Currency 1(value list USD; CDN)

amount 2  Currency 2

amount 3 Currency 3

amount 4  Currency 4

total CDN ; Total USD

  which function I used that when in put on amount 1 and select any currency (USD or CDN) it's to add in currency I chose.

please some one help  

Link to comment
Share on other sites

In general, having numbered fields is poor structure. If an entity (represented by a record in your current table) can have multiple amounts, then you should create a separate record for each amount in a related table.

Once you have done that, there are several methods you can use to sum the different currencies separately - depending, among other things, on what these sums will be used for. For display only, you could use a summary field placed inside a filtered portal. If you need them for export, or for further calculations, then it gets a bit more complicated (unfortunately, Filemaker has no built-in SUMIF function).

---
P.S. Please give your questions more descriptive titles.

 

Edited by comment
Link to comment
Share on other sites

  • Newbies

I try to make app that includes six field indicates amount.  sometime my customer pay in US and sometime in Canadian when they pay US with currency field I want that when I change to change to usd amount field calculate all amount in total field in USD Total field 

and when I change currency into CDN

it calculate into Cdn total .( these are two total fields)

important. 
some time all six field of Amount ( Which are amount 1 to Amount 6 all are in USD 

and other time all are in Canadian 

it there is a way in calculating or any function or functions I set total field 

 

Link to comment
Share on other sites

1 hour ago, saghira said:

it there is a way in calculating or any function or functions I set total field 

Yes, there is a way, but it is over-complicated. It is over-complicated because your structure is incorrect. That's why I am trying to steer you towards changing it. 

If you insist on keeping your current structure, you will have to make your total fields calculation like:

Sum (
If ( Currency1 = "USD" ; Amount1 ) ;
If ( Currency2 = "USD" ; Amount2 ) ;
If ( Currency3 = "USD" ; Amount3 ) ;
If ( Currency4 = "USD" ; Amount4 ) ;
If ( Currency5 = "USD" ; Amount5 ) ;
If ( Currency6 = "USD" ; Amount6 ) 
)

for the Total USD field, and likewise for the other.

 

Edited by comment
Link to comment
Share on other sites

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.