Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
can any one suggest an optimised formula to get the
count of items those order is one for select month and its previous month. for that it has to check select month order weather it is one or not if so it has to chek previous month order if its order is also one then it has to give the count of items.
i have 10+ lac records to apply on it suggest me an expression. see the below exmple data.
Ex data:
item | order | month | prevmonth |
Cdas | 4 | jun | may |
cfds | 2 | july | jun |
clds | 1 | feb | jan |
gdms | 1 | mar | feb |
bdms | 1 | Apr | mar |
lfgd | 4 | Aug | jul |
dqrs | 1 | feb | jan |
Hi John,
What is your expected output, can you explain it with an example?
Regards,
Jagan.
Hi Jagan Mohan
The Senario is : i have month and previous month values if i select any month in any year it has to check in that moth order is zero or not if it is yes it has to check previous month order if it so then it should return the count of item if not it shouldn't return anything.
in the above example i am expecting : if i select mar my out put is 1