Percent Calculation of Outline Over Total in Sheet and Over External Data

Panorama X
21

Jim,

Since my last posting on this topic, I have changed the name of field “D_Exp Year” to simply “Date”.

I am using the following formula to make a certain calculation:

pattern(arraynumerictotal(arraybuild(cr(),“Expenses”,“Amount”,
{yearvalue(Date)=val(2019)}),cr())
/
arraynumerictotal(arraybuild(cr(),
“Trips”,“Time”,{yearvalue(Date)=val(2019)}),cr()),"$#,")

The formula is working as expected when I summarize 2019 data not using the percent procedure above, regardless of whether I expand or collapse summaries. But it is producing unexpected results when running the percent procedure first. Can the procedure be tweaked to allow the array formula to work properly, i.e. using only the grand total of “Amount”?

Thank you.

22

I would like to say while it is good to have simple field names and that you are moving in that direction by eliminating the space and underscore, I would also suggest that you take this moment to NOT use words such as Date for a field name. A database may work just fine with a name like this but as there is a function named ‘Date’, you are only setting yourself up for confusion (or confusing Panorama) when attempting to parse your procedures. The simpler you make it, the less errors you will have to deal with.