Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I'm ussing a personal edition and I'm trying to build a pivot table to show the inventory accuracy, let me explain my two issues:
1.- I have a Oracle DB that have a fiel call Count Date in DD/MM/YYYY
I want to separate it in Days, Months and Year in order to use it like a Dimension, but I don't know how.
2.- In order to calculate the Inventory accuracy, i have 2 level to do it.
. For Item - I'm ussing two field "Stock in Sistem" and "Stock Count" and this work fine.
. For Item Family - I woul like to know how many Items are right, using
Count(DISTINCT(If(Stock in Sistem=Stock Count,Item))) This Work some time but not in all case.
see attached my app
Could someone help me with it please
HI
try this
1)day(dateField)
year(dateField)
month(dateField)
2) If(Stock in Sistem=StockCount,Count(Distinct item),0)
may it helps you
please let me know
thanks
rohit
Hi friend....you can applly the following logic
1.Day(Count Date) as Day
2.Month(Count Date) as Month
3.Year(Count Date) as Year
4.monthstart(Count Date) as Monthstart.
regards
kamal