IF AND Statement Not Working

[jontan]

Hi everyone,

Been cracking my head on this formula; what i like to present is 

1. Current GP after Profit Share 

2. For Values less than 0

IF(SUM([GP After Profit Share (EUR)])<0 AND [Accounting Year] = Year(now()))), Sum ([GP After Profit Share (EUR)])

[lironbaram]

Hi 

this expressions will only work as measure in chart 

try this 

IF(SUM([GP After Profit Share (EUR)])<0 AND [Accounting Year] = Year(now()), Sum ([GP After Profit Share (EUR)])

you had some extra brackets in your expression

[kaanerisen · Accepted solution]

Hi Jontan,

You can simply do that by using set analysis. But you need an unique field(e.g. UniqueID) in the dataset you use.

Sum({<UniqueField={"=SUM([GP After Profit Share (EUR)])<0"},[Accounting Year]={$(=Year(now()))}>}[GP After Profit Share (EUR)])

Hope it helps, 

[jontan]

Hi Lironbaram,

Solution does not seem to work though

[jontan]

Hi Kaanerisen,

It works!!! Thanks ....