Running total when two data types are similar formula 1

[12345ITguy]

Hi All,

Sorry if my request seems basic- I am a beginner

I have a set of data with the following fields-

Blue Slow Car
Red Car
Slow Car

I have running total formula as below

InStr({C_CAR.TYPE}, "Slow") > 0

The problem with this forumla is that it counts the "Blue Slow Car" and "Slow Car" together, I would like to count the "Slow Car" only.

What would be the best formula to do this? Any help is appreciated, I know there is an easy answer but it is eluding me right now.

Thanks,

 

[Madawc]

Using SPLIT and UBOUND, you could get the last two elements when there are three or more. You could then get the desired result using Distinct Count.

It depends on the other data: e.g. it would fail with "Green Slow Car Stopped"

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[swiss2007]

In Running total formula use a formula like

if {C_CAR.TYPE} like "*Slow" then true else false

 

[IanWaterman]

In the evaluate formula you do not need to spell out true false

you can use just

{C_CAR.TYPE} like "*Slow"

This will return true and evaluate RT.

However, this formula will not help as both Slow car and Blue slow car will be true.

you should use

{C_CAR.TYPE} like "Slow*"


Ian

 

[lbass]

{C_CAR.TYPE} = "Slow Car"

-LB

 

[12345ITguy]

Great, thanks everyone, very helpful indeed!