How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask jstinehelfer Your Own Question
jstinehelfer, Information Systems Manager
Category: Microsoft
Satisfied Customers: 23
Experience:  A+ Comptia Certified computer repair
Type Your Microsoft Question Here...
jstinehelfer is online now

Powerpivot formula question..The formula reads...if the month

Customer Question

Powerpivot formula question..
The formula reads...if the month = 2,5,8 or 11 execute measure X else 0.
The output executes ok except when trying get a total for the year from period 1 to 12, it returns a 0. How do i get a total that correctly adds up the outputs for period 1 to 12?
Submitted: 2 years ago.
Category: Microsoft
Expert:  adamd-mod replied 2 years ago.
Hello there,
I've been working hard to find a Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.
Please note, I am just a moderator for this category, I can only try and find experts to help, I can't answer the question itself.
Thank you!
Expert:  hongkongpom replied 2 years ago.
Hello please can you attach the document by pressing the paper clip icon but please make sure that it contains no private or proprietary information.