CODEWITHSUNDEEP
tableau-desktoptableau-cloud
Prdp
Prdp

Reputation: 57

LOD with Boolean expression

I have a parameter in a report to display exposure amount for a customer with or without closed deals.

For ex: Display exposure amount with closed deals or without closed deals.

I am struggling to incorporate this open/close flag within my existing calculation.

Below is the formula i use to calculate exposure for a customer:

i.e. I want to add a condition (Open/Close flag) to this existing formula to calculate total exposure with closed deals or without closed deals.

Appreciate your suggestion.

ifnull(
sum(
IF 
{ FIXED [Customer], [Deal], [Schedule]:
COUNTD([Buyback])} > 0
then 
{ FIXED [Customer], [Deal], [Schedule]:
AVG(ifnull([Exposure],0))}
 
ELSE 0
END
)
,0)

Upvotes: 1

Views: 36

Answers (0)

Related Questions