Help with KPI expression

[antoniodneto]

Hi guys, I'm trying to solve one expression but without sucess.

I have the following set analysis:

IF([DATABASE]='01/09/2019',
(((SUM([RISCO_CREDITO])
+((SUM([RISCO_FRN])*-1)*4.1644)),

IF([DATABASE]='01/08/2019',
(((SUM([RISCO_CREDITO])
+((SUM([RISCO_FRN])*-1)*4.1385)))

When I use this created variable vRISK on a bar chart it works perfect.

Now I'm trying to use it on a static KPI that needs to show me the value of MAX(DATE).

So I chaged the IF Statement to use  IF((MAX([DATABASE])='01/09/2019', but it doesn't work.

Could you help me guys?

[antoniodneto]

@sunny_talwar 

I tried your expression as wall but ir returning me NULL for any month.

Can you help me?

[sunny_talwar]

Lol I want to, but don't think I can. I don't know what you have and how you are using it. May be somebody else can.

[antoniodneto]

No, please.

Don't give up me.

I'm using your expression:

If(Max([DATABASE]) = '01/09/2019',
((Sum([RISCO_CREDITO]) + ((Sum([RISCO_FRN])*-1)*4.1644)))

,
If(Max([DATABASE]) = '01/08/2019',
((Sum([RISCO_CREDITO]) + ((Sum([RISCO_FRN])*-1)*4.1385)))))

But still returning NULL

[antoniodneto]

@sunny_talwar ,

Now it works, I think I was missing some ) ...

Sorry for the insistence but you saved me again.

Tks for all and sorry for something.