Hi everyone,
These two should be easy really
I have a formaula that makes a field one or zero depending on wot another field is. I then sum this item using a group total. I have 3 of these altogether, one counting all, and the other two the specific items. I then have a couple of formula's that...
I have a problem with a standard formula using if then - basically it won't display the ELSE part of the formula:
if {SPE0304.T1} = "F3" or {SPE0304.T2} = "F3" or {SPE0304.T3} = "F3" or {SPE0304.T4} = "F3" then
1
else
2;
sample data:
F3,F41...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.