summery by calculations

[Dani R]

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, 2010 by Guest

[Vaughan]

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

What is it you're trying to achieve?

[Dani R]

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" .

[Vaughan]

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

[Dani R]

i dod not understand.

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

[comment]

Hi Dani,

See if this helps:

CondAmount.zip

[Dani R]

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

[comment]

Change the calculation to =

Case ( not Status ; Amount )