Multiple of 03 as Dimension

[300sss300]

Hi,

I have Quantity (QTY) as Dimension in straight table whereas there is only one expression 

SUM(If(QTY >=3, QTY/3*1.9))

Now this expression shows all values >=  3 in QTY Dimension Field 3,4,5,6....... But I need only Multiple of 03 (3,6,9....)  as dimension in QTY field 

Just wanna help whether it will be done by adding calculated dimension or in expression.

Thanks

[vvira1316]

Something like following

NoConcatenate
QtyTmp:
LOAD * Inline
[Qty
3
4
5
6
7
8
9
11
15
17
20
];

NoConcatenate
Qty:
LOAD
Qty,
If(Num(right(Floor(Qty/3, 0.1),1))=0, 'Yes', 'No') as [Multiple of 3]
Resident QtyTmp;

DROP Table QtyTmp;

[pradosh_thakur · Accepted solution]

dimension 

if(mod(QTY,3)=0,QTY,null())

expression  SUM(If(QTY >=3, QTY/3*1.9))

suppress null.

[300sss300]

Thanks

[300sss300]

Column name is appearing as if(mod(QTY,3)=0,QTY,null())
Can we change its name

PFA

[pradosh_thakur]

On the dimesnion tab . select the dimension . On the bottom right , there is a option to give it a label. You can leverage that to change the name.