4 Replies Latest reply on May 24, 2016 7:00 PM by user19752

# I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who know how to write a calculation that works for the following:

I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who knows how to write a calculation that has multiple "If" calculations in it?

Basically I'm trying to create a calculation that is if the answer to one "if" = "Yes" then I want it to go through the "If's" below and come up with the correct fee.

If (PI_22_NetAssetsFundBallancesEnd < 49999; 25;

If (PI_22_NetAssetsFundBallancesEnd <249999; 50;

If (PI_22_NetAssetsFundBallancesEnd <999999; 100;

If (PI_22_NetAssetsFundBallancesEnd <9999999; 250;

If (PI_22_NetAssetsFundBallancesEnd <49999999; 750;

1500

If the answer to one "If" = "No"; "0"

• ###### 1. Re: I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who know how to write a calculation that works for the following:

Let(

value = PI_22_NetAssetsFundBallancesEnd;

Case(

value < 49999; 25;

value < 249999; 50;

value < 999999; 100;

value < 9999999; 250;

value < 49999999; 750;

1500

)

)

I don't understand the part about "0" because, if I understand correctly, if the value is greater than or equal to 49999999, the result is 1500.

Clear?

• ###### 2. Re: I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who know how to write a calculation that works for the following:

Hello, laurie and welcome to the community.

You can use a Case() function rather than several if statements:

possibly:

Case (PI_22_NetAssetsFundBallancesEnd < 49999; 25;

PI_22_NetAssetsFundBallancesEnd <249999; 50;

PI_22_NetAssetsFundBallancesEnd <999999; 100;

PI_22_NetAssetsFundBallancesEnd <9999999; 250;

PI_22_NetAssetsFundBallancesEnd <49999999; 750;

1500 // the default )

beverly

• ###### 3. Re: I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who know how to write a calculation that works for the following:

You calculation works if adding closing five ) , anyway this is the case to use Case() function, as

wrote.

• ###### 4. Re: I have no training on Filemaker but I'm trying to create a calculation.  Is there anyone who know how to write a calculation that works for the following:

I guess the numbers should be 50000, 250000, etc. and/or use <= operator. What value do you need for 49999 and 50000?