concatenate field value with calculated value in if condition

[eromiyasimon]

hi all,

in if condition i want to display the else value which have to concatenate with one calculated value

Attached the QVW for your reference.

[marcus_sommer]

Maybe a formatting-function will be suitable - I mean something like this:

= num(0, '(+) #.##0,0;(-) #.##0,0;(=) #.##0,0', ',', '.')

Further if I look on your monthly listboxes it could be useful to transform your data-structure per The Crosstable Load.

- Marcus

[#3]

Do u want images for addition and subtraction?

[dineshm030 · Accepted solution]

Hi Eromiya,

Use the below Queries.

Header 1
(if(rank(mar)-rank(feb)=0,'(=', if(rank(mar)-rank(feb)>=1,'(+', if(rank(mar)-rank(feb)<=-1,'(')))) &''& (if(rank(mar)-rank(feb)=0,'',rank(mar)-rank(feb))) &''& ')'

[eromiyasimon]

Thank you so much dinesh,

its working perfectly