I'd like you to help me with one thing that I have not been able to do. I created a measure called 'Invoiced Weight', that measure is calculated using the following expression:
If (chargeable_wiehgt <1, carried_weight, chargeable_weight)
If I make a table and see the expression I see that expression is working correctly, nonetheless when I want to see the sum of the 'Invoiced Weight' for any month, what happens is that the formula evaluates the expression as the following if (monthy chargeable weight <1, monthly carried_weight, monthly chargeable_weight)
Could anyone advise how could I see the sum of each services' 'Invoiced Weight'?