Hi there! My nameโs Diego, need little help.
I have a column with the sum of sales by salesman.
This is the formula of Column1 (column type Price)
SUM(SELECT(COMERCIAL[Valor faturado], AND([Atendente] = [_THISROW].[ID],AND([Mรชs] = USERSETTINGS(Mรชs),IN([Pago],LIST(โSรฃo Pauloโ,โSimโ,โNรฃoโ,โEntrada 50%โ))))))
And have a column based on the value of the column above, that give me a percentage that I will use to subsidize them.
This the formula of Column2 (column type List)
SELECT(Premiaรงรฃo Online[%PRรMIO], AND([Atingiu] >= [%META DE],[Atingiu] < [%META A]))
I need to multiply them, but I just donโt know how, Iโve tried but without success.
Solved! Go to Solution.
Is the list in the Column2 column value expected to only ever contain a single item? If so, consider wrapping the SELECT() in ANY() to convert the single-item list to singular value, then you can easily multiply the two singular values. Note that if you do this, youโll need to change the column type from List to Decimal, Number, or Percent as appropriate.
Is the list in the Column2 column value expected to only ever contain a single item? If so, consider wrapping the SELECT() in ANY() to convert the single-item list to singular value, then you can easily multiply the two singular values. Note that if you do this, youโll need to change the column type from List to Decimal, Number, or Percent as appropriate.
Hi, thanks for the commenting! Yes, expected to only ever contain a single item. Iโm going to try this and tell you if it worked or not.
Thanks a lot by the way
Thanks, it worked!
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |