Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I'm trying to write a statement that says =if(sum(Budget) > sum(Actual), 'qmem://Arrow/GreenUp',if(sum(Budget)<sum(Actual),'qmem://Arrow/RedDown'). It is not working and I'm not sure what is wrong with the syntax. Does anyone know?
Thank you!
I have updated the previous Expression, as I had written it wrong sorry
=if(sum(Budget) > sum(Actual),Red(),Green())
Hi ,
I think your syntex is right check your compared values.
Else
Try this
EX: =if(sum(Budget) > sum(Actual),'qmem://Arrow/GreenUp','qmem://Arrow/RedDown')
This does not work. I get a text box with the formula in it. Any other ideas would be very helpful!
Hi,
I think your load qmem file error so check the below syntex.
Ex: if(sum(Budget) > sum(Actual),'Yes','No')
But that would not get me to an up or a down arrow as the output, correct? How would I address the qmem file error?
Hi
I think the following will work better
if(sum(Budget) > sum(Actual),'qmem://<bundled>/BuiltIn/arrow_s_r.png','qmem://<bundled>/BuiltIn/arrow_n_g.png'))
and make sure the representation is Image
Try this:
=RangeOnly(if(GetCurrentSelections() & Budget > Actual, 'qmem://Arrow/GreenUp','qmem://Arrow/RedDown')).
this works in that I get a green arrow but I want the arrow that looks like just a triangle (without a stem).. is there a way to use this code to get that kind of arrow? Thanks! (and sorry for being picky...)
This gives me a "-" ... no arrow for now!
Try this video I created on YouTube.
Have you used Character Map before?
check this out