Forum Discussion

PNicholsonRS's avatar
PNicholsonRS
New Member
3 years ago
Solved

Conditional calculated column issue

Hi all,   I have an issue where I need to create a new calculated column from the below data that will show when an item has been billed (i.e. Billed Amt is not blank) and collected. The problem I ...
Calculated columns
  • ERD's avatar
    ERD
    3 years ago

    Hi PNicholsonRS ,

     

    YourColumn =
SWITCH (
    TRUE (),
    NOT ( ISBLANK ( Table[Billed Amt] ) ) && Table[Collected Amt] = 0
        && ( Table[WUWD Amt] = Table[Billed Amt] || Table[Written Off] > 0 ), "Yes",
    NOT ( ISBLANK ( Table[Billed Amt] ) ) && Table[Collected Amt] > 0, "Yes",
    "No"
)

     

ERD's avatar
ERD
Community Champion
3 years ago

Hi PNicholsonRS ,

 

YourColumn =
SWITCH (
    TRUE (),
    NOT ( ISBLANK ( Table[Billed Amt] ) ) && Table[Collected Amt] = 0
        && ( Table[WUWD Amt] = Table[Billed Amt] || Table[Written Off] > 0 ), "Yes",
    NOT ( ISBLANK ( Table[Billed Amt] ) ) && Table[Collected Amt] > 0, "Yes",
    "No"
)

 

MorrisBI's avatar
MorrisBI
Frequent Visitor
3 years ago

I think this could work as well. With my data example just need to modify a little bit to include the double $0 escenario (Billed and Collected), but I guess this won't happen on the real life.