topic Re: IF AND Statement Not Working in App Development

IF AND Statement Not Working

jontan — Sat, 16 Nov 2024 05:23:17 GMT

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 — Thu, 04 Jul 2019 12:02:52 GMT

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 — Thu, 04 Jul 2019 12:49:57 GMT

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 — Tue, 09 Jul 2019 06:38:25 GMT

Hi Lironbaram,

Solution does not seem to work though

jontan — Tue, 09 Jul 2019 06:42:59 GMT

Hi Kaanerisen,

It works!!! Thanks ....