Register
Log In
Unanswered
Home
March 5, 2017
Offline
Hi Guru here,I would to ask you about calculate Age,Retired date
and Seniority,Based upon your experiences how can you calculate
please give me formulas
i.e
Staff name:Yung Savuth
Date of Birth :12 Dec 1980
Date of Hired: 01 Jun 1998
Male Staff retired at Age of 60,Female at
Age of 55.
Best regards,
Dashboards
June 25, 2016
Offline
Give this a try.
The assumption is that the staff retires upon reaching 60/55 years old i.e. if today is his/her 60/55 birthday, it will be his/her retirement day.
No idea about the Seniority as you did not show how to classify that.
Hope this helps.
Sunny
March 5, 2017
Offline
Thanks,Sunny but how about seniority calculaton?
Dashboards
June 25, 2016
Offline
No idea about the Seniority as you did not show how to classify that in your question.
March 5, 2017
Offline
Hi,Sunny this test my teacher give me only this criteria.
Mynda,could you help this?
Â
thanks
Dashboards
Power BI
Power Query
April 21, 2015
Offline
I think the question is: What is Seniority?
We don't know what you mean by that so we can't give any formula or whatsoever.
Maybe it's something which is a normal expression in your country for classifying people in certain categories?
And otherwise: ask that teacher what he/she meant with that question?
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
