2 Replies Latest reply on Jul 16, 2018 7:34 AM by suvas.chandra

# Color impact at Grand Total

I have a formula like this:

TVPI Color Indicator =

IF ROUND([Investment TVPIBase],2) =1 Then "TVPI=1"

ELSEIF ROUND([Investment TVPIBase],2) <1 OR ISNULL([Investment TVPIBase]) Then "TVPI<1"

ELSEIF ROUND([Investment TVPIBase],2) >1 Then "TVPI>1"

END

I colored it: TVPI > 1 -----> Green, TVPI < 1 ------> Red, TVPI = 1 ------> Black

All the dimensions and measures work good. But the problem is, once I do Grand Total, it adds separately for Red, Green and Black. But, ideally, it is Grand Total. It should be independent of color.

Any help ? This is an screen print of Grand Total:

• ###### 1. Re: Color impact at Grand Total

I see this link for one dimension and one measure. But in my case, I have multiple dimensions and multiple measures:

• ###### 2. Re: Color impact at Grand Total

I figured it out:

IF MIN([Investment Name]) != MAX([Investment Name]) THEN "Grand Total"

ELSE MIN(

IF ROUND([Investment TVPIBase],2) =1 Then "TVPI=1"

ELSEIF ROUND([Investment TVPIBase],2) <1 OR ISNULL([Investment TVPIBase]) Then "TVPI<1"

ELSEIF ROUND([Investment TVPIBase],2) >1 Then "TVPI>1"

END

)

END