Show only 0 for one field..

[bharatkishore]

Hi All,

I have a one dimension called Cat and an expression which shows the values:

In the category i have 8 fields :

cat

a)0 to 1 year

b)1 to 2 year

c)2 to 3 year

d)3 to 4 year

e)4 to 5 year

f)5 to 6 year

g)6 to 7 year

h)More than 7 year

In this i have More than 7 year column only for this i want value to be 0.. Please see the below image for reference:

cat	Exp
a)0 to 1 year	5,626
b)1 to 2 year	4,559
c)2 to 3 year	3,874
d)3 to 4 year	3,489
e)4 to 5 year	3,239
f)5 to 6 year	2,349
g)6 to 7 year	2,051
h)More than 7 year	12,745

Here i have value with 12,745 but i want value should be 0 always what ever filters i make.

Please let me know if you require anything more..

Attached app for reference

[tresesco · Accepted solution]

Try exp like:

If(cat='h)More than 7 year', 0, Sum({<MonthYear="$(=Date(MonthStart(YearEnd(Max(MonthYear),-1)),'MM/DD/YYYY'))"}>} IB))

[pradosh_thakur]

hi

please find the attached.

regards

Pradosh

[bharatkishore]

Thanks Tresesco. i missed (cat='h). I have given

if(cat='More than 7 year', 0, Sum({<MonthYear="$(=Date(MonthStart(YearEnd(Max(MonthYear),-1)),'MM/DD/YYYY'))"}>} IB)).

That is where i missed..Thanks again.

[bharatkishore]

Thanks Pradosh..

[vinayakg]

Hi Bharat,

Please Check the attachment