My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Comments
-
Hi, Expenses This indicator shows the total debits to income and expense accounts during the selected period(s). You can click this KPI’s periods or totals to open the Income Statement Report. Operating Expenses This indicator shows the dollar value of operating expenses during the selected period(s). You can click this…
-
Hi You are welcome it is a pleasure for me to help you out First of all, the formula field are really acting exactly like SQL. If you want to have more info about the function you can enter in the HELP ; SQL. The first result will be a complete list of these function, it is also give you some example and description of…
-
Hi If you just want to do(Return Authorization)/(Invoice) You can do this In the results sublist, Field : Formula(Text) Summary Type : Maximum Formula : TO_CHAR(TO_NUMBER(COUNT(NULLIF({type},'Return Authorization'))/COUNT(NULLIF({type},'Invoice')))) You can't use the CASE WHEN. I'm not sure it is possible. I can do some…