Forum Discussion
Formula
how to calculate and get percentages in a column?
Hello Augustas-ase here's something that may be helpfull
or how can i multiply this? sales 2022 x %ct sales 2022
For any calculations you need to use calculated columns or measure
how to calculate measure? then for example, Sales 2022 value: cow is 544,385, and how to measure i can get percentage 43,06?
You got a column sales 2022 with value 544,385
Then you have a create an other calculated column for to get 43.06%
Formula for the column is :-
#column =
VAR _total = SUM([Sales 2022])
VAR _val = [Sales 2022]
RETURN
ROUND((_val / _total)*100,2)
then later you can use the #column For other calculations