Skip to Content
0

SUMGT calculated KF

Feb 13, 2017 at 03:47 PM

36

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Varaprasad Raju Potturi Feb 15, 2017 at 06:11 AM
0

Hi,

Can you try :

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

Thanks,

Raju

Share
10 |10000 characters needed characters left characters exceeded