Skip to Content
0

Reg : Webi Formula / Variable to identify same amount consecutive cells and Flag it

May 23, 2017 at 08:30 AM

18

avatar image

Hi Friends,

I have requirement. I need to create an Expenses Exception report, where I need to identify is there any expenses that got duplicate or claimed twice by Employee.

So to get I have sorted based Employee and Amount for a Period of selection.

Now is there any way that if the amount is same consecutively I want to flag it and Filter this flag.

See below example

capture-2.png (56.7 kB)
10 |10000 characters needed characters left characters exceeded

Hi,

You can try this

= If([Employee] = Previous([Employee]) and ([Amount] = Previous([Amount]) In ([Employee])) ) then 1 else 0

Apply conditional format on above formula and assign to 1.

Thanks,

Jothi

1
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sreekanth P May 23, 2017 at 09:03 PM
0

Thanks a lot Jyothirmayee.

Regards

Sree

Share
10 |10000 characters needed characters left characters exceeded