Skip to Content
avatar image
Former Member

SUMGT calculated KF

hi,
I have created a CKF1 which is checking if the enddate > 60 days than the begindate. CKF1 = GT("Enddate",MAX("Begindate",60))
Now I am trying to SUMM up a revenue field based on the CKF1 field. If the result = 1 it should SUM the revenue otherwise not. I tried something like this SUMCT("Revenue") EQ ("CKF1",0)) but the syntax is not right. Is this possible? if so what should be the syntax?
any help is appreciated.
br, Ralph

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 15, 2017 at 06:11 AM

    Hi,

    Can you try :

    SUMCT("Revenue")* EQ ("CKF1",1)

    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded