Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello again!
Please help to find adequate function. I need to do a concatenate in my Chart table.
I have two columns: a and b with the values ..
I need to get expression like this:
= 'a + b' = Text(a) + ' + ' Text(b) + ' = ' + Text(a +b)
Which function I have to use instead of Text and how can I make concatenation?
Thank you in advance.
I think what if you try just this:
a & ' + ' & b
where & is used to concatenate here
I think what if you try just this:
a & ' + ' & b
where & is used to concatenate here
Hi,
Check out string functions in the QV Help File.
HTH
Andy
Can you please tell me also, how to make Number format to x.xx and to x (integer)?
Thanks in advance!
Try Num() or Round function:
=Num(NumberField, '#,##0')
or
=Round(NumberField)
UPDATE: This number seems to be within a text? Is this the field where you are concatenating bunch of fields?
These are evaluated values .. like
sum(IF(InMonth(Bouth__PostingDate,Today(),-3),Bouth_Cofee_Item_Money,0))
Then this:
Num(Sum(If(InMonth(Bouth__PostingDate,Today(),-3),Bouth_Cofee_Item_Money,0)), '#,##0')
or
Round(Sum(If(InMonth(Bouth__PostingDate,Today(),-3),Bouth_Cofee_Item_Money,0)))
Thank.
That works perfect.