Forum Discussion
Custom Column Query
Hi all,
Wondering if someone can help me please. I have trying to write a query so that if a column is less than 8 then this will combine a string and another column. However for some reason it is continiously showing blank.
The formula I have is:
if [ReportingMonthNum] < 8 then "FY" & [YearNum] else ""
The reporting monht column has values ranging from 1 to 13 and the "YearNum" will show our year number for example, 15, 16 or 17 etc... I am trying to combine this with some text "FY" however my columns are continuing to show blank.
Can anyone point me as to where I am going wrong please.
You can't concatenation text with numbers. Convert the number first.
Number.ToText([YearNum])
7 Replies
You can't concatenation text with numbers. Convert the number first.
Number.ToText([YearNum])
Thank you this worked, however this is ignoring double numbers for instance I have added to the query so that if th Reporting Month is greater than or equal to 8 however this does not work if the number is 10, 11, 12 etc... Might you have any ideas why please?
Sorry, I don't understand. Can you post your new formula?
