Forum Discussion
Help with Timing Issue for Totals
I'm trying to create a comparison of my company's actual financials vs. budgeted vs. proforma forecast. All numbers are reported on a monthly basis and we follow an academic calendar that starts in A...
Hi fsy,
Based on your error message, it seems like you are try to compare date value with text value. Did you ensure you input the right columns in your formula?
In addition, can you please share the sample file? I will test on it and try to modify your formula.
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
I couldn't figure out out to upload my files onto this forum, so I've uploaded the to the Dropbox link here:
https://www.dropbox.com/sh/w46j50uwob4k7wi/AADNQqNkY8whh5paI7YGCX5Wa?dl=0
If there is another way I need to get files to you, please let me know. Really appreciate this!
Hi fsy,
I find you have miss the '&' character.
Notice: '&' equal to CONCATENATE function, '&&' means and logic.Budget YTD = calculate([Budget], FILTER(ALL(DateTable),[DateKey]>=date(2011,1,1)&&[DateKey]<=date(2017,6,1)))
Regards,
Xiaoxin Sheng