Forum Discussion

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

did you try this

format (
        calculate (
            sum ( sale_order_line[Subtotal by Company Currency] ),
            sale_order_line,sale_order_line[state]  IN {"draft", "sent"}
            )
            , "# ##0.0 ") & SELECTEDVALUE(sale_order_line[company_currency_symbol])

 

 

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
2 years ago

I did not, because it converts the value to text, which makes it useless for further calculations. 
Also, it keeps multiplying the rows.