Hi guys,
I have a calculate field which calculate of projects in my portfolio:
COUNTD([Iniciativas ]) / WINDOW_SUM(COUNTD([Iniciativas ]))
I have other situation, now i want to calculate % of projects which the date is not null,
any idea how I could do that?
Best,
Lucas
1 answer
Can you share a sample .tbwx file to have a closer look so we can provide concreate expression.?
Where are you using this expression? Can't you write something like below
IF NOT ISNULL(ATTR([DateField])) THEN COUNTD([Iniciativas ]) / WINDOW_SUM(COUNTD([Iniciativas ])) END
