Forum Discussion

spencer_II's avatar
spencer_II
Icon for Helper I rankHelper I
5 years ago
Solved

If then statement returns all values

Attempting to use an if, then statement so that IF a column has a certain value then calcuated result will either return a "%" or text value that indicates "No number" eg. If(sum(uplift cases)<1, "N...
Need Help
  • spencer_II's avatar
    spencer_II
    5 years ago

    Thanks for reviewing post... I think I found a solution.  I put the If/then as a calculated column and then used that column in my table.

    Now when customer is selected in slicer it only shows that customers.

     

    Thanks, Spencer_II

spencer_II's avatar
spencer_II
Icon for Helper I rankHelper I
5 years ago
Case % Lift = If(sum(Tbl_BPPromoSumry[Uplift - With (m1052)])<1,"No Uplift",
DIVIDE(sum(Tbl_BPPromoSumry[Uplift - With (m1052)]),sum(Tbl_BPPromoSumry[Base Shipments (m4120)]),0))

 

Expected result:

Returned result:

 

 

spencer_II's avatar
spencer_II
Icon for Helper I rankHelper I
5 years ago

Thanks for reviewing post... I think I found a solution.  I put the If/then as a calculated column and then used that column in my table.

Now when customer is selected in slicer it only shows that customers.

 

Thanks, Spencer_II

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi spencer_II ,

    Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

    Best Regards,
    Community Support Team _ Yingjie Li