Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Replace value in visual table

The last column (marked in red) of the table is determined by the value of the yellow column minus the value of the green column       And I need to replace the value of this last column wi...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , try like

     

    Sumx(sumamrize(ft_repasse[UF], ft_repasse[Orago APRENSOR]), CALCULATE(IF(SUM(ft_repasse[saldo]) < 0, 0, SUM(ft_repasse[saldo]))))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , try like

 

Sumx(sumamrize(ft_repasse[UF], ft_repasse[Orago APRENSOR]), CALCULATE(IF(SUM(ft_repasse[saldo]) < 0, 0, SUM(ft_repasse[saldo]))))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

     it worked for me, thanks