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
jstinehelfer, Information Systems Manager
Category: Microsoft
Satisfied Customers: 23
Experience:  A+ Comptia Certified computer repair
63323962
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: 1 year ago.
Category: Microsoft
Expert:  adamd-mod replied 1 year 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!
Adam
Expert:  hongkongpom replied 1 year 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.