I need to setup query that will give me the variance between two fields. right now i’m useing ” Var: [quantity in system]/[physical counted] ” in the query filed. this gives me the percentage and sometimes its over 100 sometimes its under 100.
so what I like to get done is that when it is over 100 I get a (+)(what ever percetgae over 100) and when its under 100 i get a (-)(what ever percengae under 100). for example if my var is 133% i like to see +33% or when its 65% I like to see -35%.
Can you please help me do this?