Forum Discussion

harib's avatar
harib
Post Patron
7 years ago

IF conditional column

Hello Friends,   I want a conditional column in my table report like if condition or anything  I have a 3 groups like BG, CMT, Country groups (column wise) I would like to apply TARGET_PERCENT or...
Need Help
Tips and Tricks
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi harib ,

 

Try this one.

Target =
VAR a =
    IF (
        ISBLANK ( [Target Percent BG] )
            || [Target Percent BG] = 0,
        80,
        [Target Percent BG]
    )
VAR b =
    IF (
        ISBLANK ( [Target Percent] )
            || [Target Percent] = 0,
        80,
        [Target Percent]
    )
RETURN
    a + b
  • harib's avatar
    harib
    Post Patron
    7 years ago

    v-frfei-msft 

     

    Hi it's giving aggreagate value like below image, it should show only 1 value either 80 (or) Target Percent BG (or)  Target Percent table values.

    You have not mentioned any group in the formula if i'm not wrong

     

    Thanks for appriciate if you can provide best solution