Is this Calculation format correct?

Posted on 2010-01-02
Last Modified: 2012-05-08
I have put together a monthly commission totals layout that summarises the monthly figures using repeating fields. This works fine when I use the underlying calculation field:
[Monthly]  Caculation [12] unstored, = Case(Get(CalculationRepetitionNumber) = Month(Extend(Date_Written)) ; Extend(cgComm))

However, I want to be able to interchange the Date_Written field for Date_Completed along with some other date options. I have tried the following but now the figures do not calculate:

Calculation [12] unstored, = Case(Get(CalculationRepetitionNumber) = Case(Status = "Written"; Month(Extend(Date_Written))) ; Extend(cgComm))

Status is a Global value. I figure if this works I can add further case options such as Status = "Completed"; Month(Extend(Date_Completed)) etc.

Is my Calculation correct, have I structured it incorrectly or is there some other factor to take into account?
Question by:c0link
    LVL 28

    Accepted Solution

    My first clue would be to extend "status" as well. it may sound weird, but calculated repeating fields require extending any operand field which is not, be it global or standard.

    Author Closing Comment

    Brilliant !!

    Seems obvious now but nevertheless I couldn't see it.

    Thanks for your help, it has saved me vital time.
    LVL 28

    Expert Comment

    not really brilliant, but been trapped before!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now