Format of column dynamic

[TITO22]

Hello everyone,

I want to make the format of my column Sales/QTY dynamic according to the ProductID:
when ProductId = 2 ==> 2 decimal
ProductId = 3 ==> 3 decimal
Please check the table below

Product Id	Sales/QTY
100	3
1	0,2
2	0,03
3	0,005
4	0,0006

Thank you

[Anonymous · Accepted solution]

Hi @TITO22 

Sample:

You can create a measure as follows.

Sales/QTY1 = 
VAR _rept = MAX([Product id])
VAR _sales = MAX([Sales/QTY])
VAR _number = IF(LEN(_rept) = 1, CONCATENATE(REPT(0, _rept), _sales), _sales)
RETURN
IF(LEN(_rept) = 1, LEFT(_number, 1) & "." & RIGHT(_number, _rept), _sales)

Modify the Format:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TITO22]

Thank you 👍