Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Yr/Qtr Tr value Arrow
201001 100 Up Arrow image
201002 90 Down Arrow Image (because the Tr valule is lessthan the previous Tr value)
201003 120 Up Arrow Image (because the Tr valule is Greater than the previous Tr value)
201004 110 Down Arrow Image (because the Tr valule is lessthan the previous Tr value)
I created one table dashboard with the fields Yr/Qtr and Tr Value
And third field Arrow is calculated field which will show images in that field
I want the third field with the images (Up and Down) which I mentioned in the above
So how I can generate third field with the comparision operator and display the images.
Pls guide me
Thanks,
Hi,
Would this be for a chart? or a textbox for like a report object? because i tried this before and the only solution i found was to use the font Wingdings "h" and "i" for the up and down arrow and i just added a color change for down to be red and up to be green in the font color with a formula
sample:
If([Tr value] > 100,'h','i')
using the wingdings3 font..
hope this helps..
Hi,
have a look into the ABOVE-function - see the attached file
HTH
Peter