Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,362,963
Community Members
 
Community Events
168
Community Groups

Easy bi for measurement

Hello team 

 

Im using easy BI , im new , but i find some difficulty in writing measurement condition (IIF).

 

My code is 

[Measures].[ prévisionnel restant]

CASE
WHEN [Measures].[Montant engagé (TTC) created] > [Measures].[Montant prévisionnel (TTC) created] THEN 0
WHEN [Measures].[Montant du règlement (TTC) created] > [Measures].[Montant prévisionnel (TTC) created] THEN 0
ELSE [Measures].[Montant prévisionnel (TTC) created] - [Measures].[Montant engagé (TTC) created] - [Measures].[Montant du règlement (TTC) created]
END

 

But it takes only the third case althought if case one are right.

In case 3 fact 24 : (Montant prévisi )32000..... < 40000 ( montant engagé ) it's right but they dont take it in concideration

I like to get this result 14500 not 5500.

 

Please find below all details 

 

 

Image 3.png

 

regards

Karim

 

 

1 answer

0 votes
Fabian Lim Community Leader Nov 17, 2021

Hi @karim

You need to review your formula.  There could be conflicting statements.

Try something like this:

CASE
WHEN ([Measures].[Montant engagé (TTC) created] > [Measures].[Montant prévisionnel (TTC) created] OR [Measures].[Montant du règlement (TTC) created] > [Measures].[Montant prévisionnel (TTC) created])

THEN 0

ELSE [Measures].[Montant prévisionnel (TTC) created] - [Measures].[Montant engagé (TTC) created] - [Measures].[Montant du règlement (TTC) created]

END

 

Regards,

Fabian

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events