need Help

[saghira]

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  

[comment]

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 September 22, 2022 by comment

[saghira]

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 

 

[comment]

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 September 23, 2022 by comment

[saghira]

Thank you