[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

Is this Calculation format correct?

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?
  • 2
1 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.
c0linkAuthor Commented:
Brilliant !!

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

Thanks for your help, it has saved me vital time.
not really brilliant, but been trapped before!

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now