hi

how can i make a calculations of s filed "amount" that will do a summery only if filed "check box" value = "yes"

Edited September 5, 201015 yr by Guest

Have you looked into the GetSummary() function? It relies on the records being sorted correctly.

What is it you're trying to achieve?

i am trying to achieve a calculation of amounts that will do a summery of the value only if in another filed named "check box" will have a value ="yes" .

The term "summary" has a particular meaning in FMP. Summaries usually refer to summary reports and these apply to found sets of records.

i dod not understand.

so how can i do a calculation of filed amount by a condition of a another filed?

Hi Dani,

See if this helps:

CondAmount.zip

it is great thank you .

but my mistake how can I change it that if stauts is not checked it will go in to "cConditionalAmount" ?

thank you dani

Change the calculation to =

Case ( not Status ; Amount )