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

[former_member228877]

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

[jyothirmayee_s]

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

[former_member228877]

Thanks a lot Jyothirmayee.

Regards

Sree