Set Analysis

[kishoreravi1983]

Hi All,

I have a small Issue while writing Set Analysis

This is My exp displayed in KPI Object

Avg({<ReferenceDate={'EDACloseCompleteDate'},EffortType={'Research/POC'}>}DataWranglingDays)+
Avg({<ReferenceDate={'ETCloseCompleteDate'},EffortType={'Build'}>}[EDA-GovDays]) +
AVG({<ReferenceDate={'POC-BuildDecisionDate'},EffortType={'Build'}>}[POC-BuildDays])

 I am summing up all the Avg Days, but what the issue if due to filter if any column doesn't meet the selection it is Showing blank. but other two i have values. I would want to display Values of Others if one is not meeting the criteria of selection on Front end.

Let me know how to correct the expression.

Thanks

Ravi

[Channa]

expression looks good try to make as suppurate and see which one has problem

try use = before expression and use open close for each expression

[marcus_sommer · Accepted solution]

Try it with: rangesum(avg1, avg2, avg3) instead of: avg1 + avg2 + avg3.

- Marcus

[kishoreravi1983]

Thanks Markus. This Worked